ranking top 10

[surajap123]

Hi Experts,

I want to show top 10 products based on its percent. Please help.

[qv_testing]

May be this...

if(aggr(rank(sum(Margin)/sum(Sales)),Product)<=10,sum(Margin)/sum(Sales))

[bc-thebruuu]

What is your expected result?

As far as I see,

Product should be sorted alphabetically and Region wrt to the expression you used for product

[surajap123]

Hi Raju,

Thanks for the expression.

Sorry, I have slight change in the requirement. I actually want top 10 worst products and the product dimension should be sorted alphabetically.

Thanks!

[Anonymous]

Hi

your expected o/p may be like below

[YoussefBelloum]

take a look at this:

[qv_testing]

PFA,

[surajap123]

Thanks Youssef & Raju,

I tried to implement it in my main application. But our application has many expressions in the pivot table which is causing issue.

I am wondering if i can use the same expression to create a calculated dimension, so i can have the correct worst 10 products always.

=if(rank(-(sum(Margin)/sum(Sales)))<=10, sum(Margin)/sum(Sales))

Could you help me with the expression.

[YoussefBelloum]

Hi,

to be able to show the worst 10 dimension values correctly on your pivot table when you have multiple measure, you should add the Ranking condition on EVERY measure

[surajap123]

Hi Youssef,

Infact i have only one measure. All the other measures are background colors and trends based on the same main measure.

So, instead of modifying all the expressions in the chart. I think, its eazy to use calculated dimension.

Please help with the expression.

Thanks!