How to find Sales by rank

[#1]

Hi

I have a Deliver table is there ..

a     b     c     d     Sales

1     x     y     z     100

2     m     n     o     200

3     c     d     e     300

4     i     j     k     500

for this above data,i want to find the rank based on dimension .my data will show like this

I have a Deliver table is there ..

a     b     c     d     Sales  Rank

1     x     y     z     100     1

2     m     n     o    200     2

3     c     d     e     300     3

4     i      j     k      500     4

Can any one please write expression fro this one...

Thans

[MK_QSL]

Aggr(Rank(-SUM(Sales)),Sales)

[#3]

Hi Roshan,

write this expression in your chart

rank(TOTAL(-1*sales))

or

rank(TOTAL(-1*a))

Lalit