Ranking based on the measure value

[apthansh]

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.

[Kushal_Chawda]

Ideally it should work. Would you be able to provide sample data with expected output?

[Steven_Haught · Accepted solution]

You could try this  I use  something similar in a like table for sales ranking:

=Aggr(Rank(Sum(Sales])),ID)

[ramchalla · Accepted solution]

you can try this below formula.

IF(Aggr(Rank(SUM(Sales),4),ID)<=20,Aggr(Rank(SUM(Sales),4),ID))