3 Replies Latest reply on Jun 20, 2018 8:41 AM by Ciaran Bource

    Top N Clients (and "Others") by Country and Year

    Erick NIZARD

      I have a data file that has Year, Country, Client and Sales.

       

      I am trying to create  a viz that displays the Top N client by country and by year (based on parameter) and bucket the rest as "Others"

       

      I have created the Set and the Parameters.

       

      While i am able to get the desired result if i don't filter on Country, once i add the country as a Filter, it doesn't work i.e. it still seems to calculate the Top N based on the total file (i.e. across all countries) vs. aggregating by country first.

       

      Any insight?