How to get rank properly when multiple dimension have same metric value ?

[shekhar_analyti]

Hi All ,

How to get rank properly when multiple dimension have same metric value ?

Item	Sale	Rank
A	20	1
B	10	2
C	8	3
D	5	4-5
E	5	4-5
F	2	6-7
G	2	6-7
H	1	8-9
I	1	8-9

Expected

Item	Sale	Rank
A	20	1
B	10	2
C	8	3
D	5	4
E	5	4
F	2	5
G	2	5
H	1	6
I	1	6

[sunny_talwar]

Just what you need

Continuous Ranking (no missing Rank)

[shekhar_analyti]

Response for Faster than time taken to submit after pressing post button

[sunny_talwar · Accepted solution]

Use this expression

Div(Index('-' & Concat(DISTINCT TOTAL Num(Aggr(Rank(Sum(Sales),1,1), Item), '00000'), '-', -Aggr(Sum(Sales), Item)), Num(Rank(Sum(Sales),1,1), '00000')), 6) + 1