Ranking

[prajapatiamar38]

Hi Experts.....

i want to give a proper ranking to expression...
i had used rank 1,1 format...
m getting following output..

value	rank((value),1,1)
10	1
20	2
20	2
30	4
40	5
50	6
50	6
50	6
60	9
80	10

expected output

value	Expected_rank
10	1
20	2
20	2
30	3
40	4
50	5
50	5
50	5
60	6
80	7

plz Help me..
thanks in advance...

[Kushal_Chawda]

Try,

Expression - Rank( Total sum(Value))

[prajapatiamar38]

i had used the same expression...
but not giving output with the same.....

[swuehl]

Maybe like attached.