To combine 2 "Top N" conditions on a measure, the easiest way is probably to create 2 sets based on the dimension you're talking about. Then to combine the 2 set in a "combined set" and to set up what elements you want it to to return.
Create a set:
Set up your top logic:
Repeat the process on the same dimension with another top N logic and then combine the 2 sets together:
Here is a complete explanation of sets in tableau:
Hope this helps!
Thanks for your quick reply but unfortunately haven't been able to solve my issue as it won't let me create a combined set?
Any other ideas/if you know what I'm doing wrong in the original method you posted?
Don't know have you gone through these kb articles or not?
Hope this help.
If you still unable to get your desired output then kindly share some sample workbook in .twbx format.
1 of 1 people found this helpful
Hi Henrietta, can you share a packaged workbook for us? Or at least a screenshot of what you see?
Until then, what I'd recommend is trying to use a table calculation to get the top N. Try to arrange your rows in descending order and then use a formula like this:
LAST() < [Parameter for N]
Set this to compute along Table Down.
If you can't get the rows to sort properly, you might have to create some sort of combined dimension and put that as the farthest-left pill in the rows shelf.
Unfortunately I am unable to share a packaged workbook as the data contains privileged customer information but will try the methods you have all suggested, thank you!