Top 10 Products Flag

[profilejamesbond]

Hi,

I have sales data where I have sales by country, region, and city.

Now, I would like to add filter in the app which contains top 10 sales products name while rest of the products mark as "Other".

How to do it ?

Thanks

[seanbruton · Accepted solution]

Hi,

Please could you advise what visualization would be impacted by this, is it a Table or Bar, Combo and Line Charts.

In most charts under the dimension in properties there is a limitation selection where you can setup exactly that.

If you are using a table try the below script in your first dimension.

if(Rank(total Sum(Sales))<=10,sum(total aggr(if(Rank(total Sum(Sales))<=10,Sales),country, region,city)))

Regards

Sean