I understand how to use a top n set, but when I try to apply the top n set to multiple rows instead of just one it doesn't work. For example, say you want the top 5 cleaning products for a store - the set works. When I add in a pill to rows that has multiple stores, it shows the top 5 cleaning products but not for each store individually. Is there a way to do this using sets (I know it's possible with Index but I prefer using a set)
1 answer
Hi Ori,
Using sets or Top N in the filter option is done for the dataset as a whole, if you're looking at nested top N the table calculations (such as index as you mentioned) is the recommended: https://www.theinformationlab.co.uk/2015/06/16/showing-a-nested-top-n-with-other-in-tableau/
Thanks,
Mavis
