This content has been marked as final. Show 3 replies
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.