Tableau Top N Item ranking with Other tutorial

In this video, I will be going over how to do a top N ranking of sub-categories with an 'other' rollup of the remaining sub-categories for each category partition using the Sample Superstore Dataset provided by Tableau.

[elainesun]

finally found this video to solve my proble problem！thank you

[shayyyyyyyyyyyyyyyyyyyyyy]

Thank you for the video. How can this be modified to ensure ties are handled and other category is always shown along with Top.

[ghbronner]

Great video. I would suggest that instead of sorting on Sub-Category, create a combined field with Category and Sub-Category, and replace Sub-Category with it. Create the Sub-Category plus other exactly like you did. However, compute all table calculations using the combined field instead. The reason behind this is that in the video, you're sorting not by Sub-Category within Category, but instead by Sub-Category as a total. This would create problems if there is the same Sub-Category value within two or more Categories (which is the case for many of us watching this).