9 Replies Latest reply on Nov 28, 2016 3:55 AM by Simon Runc

    Sets with Top N and the rest as "Other"

    Matthew Weir

      Hi Everyone, I need some help with Sets and Top N. I want to show the top ten countries for a selected (filtered) region and group the rest of the countries in that region one category. I can get it to work when having all the data in view, but not when the region filter is applied as the results of the set are not grouped/filtered by the region. Using Index() I can get the proper groupings/rankings, but cannot mix the aggregate Index() formula with the non aggregate Country field in order to group the countries that fall outside of the Top N. I cannot readily share my data, but can create some dummy data if that would be helpful.

       

      This is what I used to set up the set and Top N

      http://kb.tableau.com/articles/knowledgebase/top-n-and-others-sets

       

      Jonathan Drummey