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



      Jonathan Drummey