How to Create rank on Calucalted column.

[#1]

Hi i want to show rank for calculated coumn

i created one expression for total::::::

sum({<[Manager Name Lvl 03]={'dimm'}>}  Amount)

its giving sum total like below

manger   AMOUNT

A            100

B             300

C             500

Now i want display rank also

manager     amount  rank

a                 100         3

b                  300        2

c                 500         1

[israrkhan]

try like

Rank(sum({<[Manager Name Lvl 03]={'dimm'}>}  Amount))

OR

Rank( - sum({<[Manager Name Lvl 03]={'dimm'}>}  Amount))

minus sign to show rank in reverse order....

[#3]

its giving 1,1,1,1,1

its not giving exact output

[israrkhan]

it must work...

can you please share a sample document...i can help you in better way..