Add a rank column to straight table

[#1]

Hi I want to add a column to rank the accounts by Total Units. I sorted by Total Units and added the Rank expression but is not displaying as I am expecting it to. I would like to see Account E listed as 1, Account C listed as 2, Account D listed as 3 and so on.

I use this as the expression =rank([Total Units]) but only returning 1s

Total Units is Sum({CalendaryYear = {$=max(CalendarYear)}>} QuantityShipped)

Please help, thank you in advance!

[fsimoes81]

It's strange, rank([Total Units]) it should work.

Try Rank(Sum({CalendaryYear = {$=max(CalendarYear)}>} QuantityShipped))

[#3]

I tried that too but still same result

[fsimoes81]

Are you have a example (qvw)?

Please, if possible, send a reduced qvw.

[#5]

I got it to work, thank you