1 of 1 people found this helpful
I feel I'm missing an obvious, more elegant solution, but here's what I've come up with in my sleep-deprived state:
Is this what you're looking for?
The three coloured lines are the sum of sales for the three selected sub-categories in the superstore sample set, the black is the sum of sales across all sub-categories.
I created a sub-category set and defined the members I wanted to see (called [Which sub categories to show]), then created a calculated field, which I then dragged to colour:
IF [Which sub categories to show] THEN [Sub-Category]
Then I edited the colour for Null to be white. See attached.
Hope this helps!
This is exactly what I am looking for. Thank you! This solution works.
Glad to hear it!
Don't know how you plan to select the members of the set that are to be shown, but you could try the set actions feature that came out a little while ago.