Top 10 product sales over 10 weeks

[Anonymous]

Hi,

I have multiple products and want to get the top 10 products based on the total sales of the product in each week.

I will be using this in a line chart which will show the sales trend of the top 10 products across 10 weeks. It keeps giving me more than 10 products which is not what i wanted. Are there any ways to do it in data load editor?

[Anil_Babu_Samineni]

First step, can u try this im UI?

If(aggr(rank(sum(TOTAL <week> sales))<=10, product), product)

[Anonymous]

It doesn't display anything? Only a straight line is shown

[Anonymous]

I have done an example of how i wanted it in Excel. I use filters to achieve this.