Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below table - I want to rank based on the sales - I have almost 20 columns in the table with multiple dims & Measures
ID | Sales | Loss | Rank |
1 | 50000 | 3000 | 3 |
2 | 90000 | 4000 | 1 |
3 | 70000 | 5000 | 2 |
4 | 20000 | 6000 | 4 |
5 | 10000 | 7000 | 5 |
I tried Rank (Sum( Sales)) which is giving me only 1 as value, instead of 1,2,3,4,5..Not sure why..any thoughts please ?
Thank you much.
You could try this I use something similar in a like table for sales ranking:
=Aggr(Rank(Sum(Sales])),ID)
you can try this below formula.
IF(Aggr(Rank(SUM(Sales),4),ID)<=20,Aggr(Rank(SUM(Sales),4),ID))
Ideally it should work. Would you be able to provide sample data with expected output?
You could try this I use something similar in a like table for sales ranking:
=Aggr(Rank(Sum(Sales])),ID)
you can try this below formula.
IF(Aggr(Rank(SUM(Sales),4),ID)<=20,Aggr(Rank(SUM(Sales),4),ID))