Hi,
I have chart looking at sales over time, split by the dimension member. In each pane there are two lines:
1) the sales for that member
2) the sales for all members
I'd like to change (2) to 'sales for all members, minus any members selected from a set'. This is to compare sales for member A to sales for all members minus member A, or sales for all members minus members A+B. My initial idea was to do this using sets plus a fixed LoD. It works well, except for the pane which has a member excluded. In this case, line (3) just shows the sales for that member, not sales minus that member's sales. In the example attached, when I deselect 'Home Office' from the set, I expect to see £56.9k in the January value for 'Total Segment Sales'. However, instead I see £7.5k. Attached example poses the question in a tabular format.
Thank you!
Jacob
@Jacob Robinson
Hi, maybe what you need is:
{FIXED Year([Order Date]), MONTH([Order Date]): SUM(IF [Segment Set] THEN [Sales] END)}If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
Tableau Ambassador
