Top 10 sales Product for each month for business line TSS Cumulative on a line chart

[Geostidet]

Hi all how can I get the 

Top 10 sales Product for each month for business line TSS Cumulative on a line chart.

I try this set Analyse.  with no success  

Sum({<IsPrioYear={1},Product ={"=Rank(Sum({<IsCurrYTD={1}[Business line]={'TSS'}>}Sales))<11"}>}Sales)

[MatheusC]

Hi, @Geostidet 

Sum({<Product = {"=Rank(Sum({<IsCurrYTD={1},[Business line]={'TSS'}>}Sales),4)<=10"},IsPrioYear={1} > }Sales)

Regarts,
Matheus

[mato32188]

Hi,

there is a small typo in set expression - comma is missing, but I am not sure, if this is the real issue.

For Line chart:

Dimension - reporting year

Measure - Sum({<IsPrioYear={1},Product ={"=Rank(Sum({<IsCurrYTD={1}, [Business line]={'TSS'}>}Sales))<11"}>}Sales)

Measure modifier - Accumulation

It should work now.

BR

m

[Geostidet]

Hi @MTHEUSC,

Thanks for the quick response. but I am still having the same issue with the formula you provided it doesn't   filter out the top 10 of    Business line TSS. I only have the Top 10 of TSS if I add a   Business line filter on the dashboard and select TSS.

[MatheusC · Accepted solution]

@Geostidet 
Let me know if there are any more details, according to the information provided in the table, the expression I provided brings the top 10 values ​​correctly.

Regarts,
Matheus

[MatheusC · Accepted solution]

Did you get the solution?

Close the topic with the solution met and leave a like if you found it useful.

Thank you!