You might want to look at this KB article: http://kb.tableausoftware.com/articles/knowledgebase/top-n-and-others-sets
I used a similar technique in the attached dashboard to show how it might be accomplished. You mentioned that you only wanted to show "Other" if all categories were selected. This is possible to do, using a table calculation to evaluate the number of categories in the view and comparing to the total number of categories in the data set. However, I suspect, that you may like the following option:
Instead, I made Category a context filter. That means that the Top N Brand set is calculated within the context of the selected Categories. If the category selection ends up with more than N brands, you'll get the Top N + Other for the categories selected. Otherwise, you'll just see the brands for the selected categories without other.
I also demonstrated how you can dynamically change whether to show the "Other" group or show all groups.
Please let me know if you have any questions.
This is precisely what I was looking for- the option to dynamically calculate my 'Other' group works perfectly! Thank you so much. A lesson learnt for me!
One more quick question- if I then wanted to go one step further and build the same stack bar for Margin i.e. my Brand contributions to the Margin bar but totalling to the total company margin how do I do that? I tried using:
But my right side scale for margin goes into 1000s% rather than showing the breakdown within 33%. Any idea? Attached it again in an updated version.
So sorry if I am distracting you in anyway, really new to Tableau and trying to learn my way through!
Thanks a ton,
Apologies Joshua, I think I found the solution myself.
and it worked! Unless you got any other suggestions!
I think that should work well! Glad to help!