Rank function

[vijetas42]

Hello All,

Need your help with Rank().When I am applying rank() in grid its giving me correct rank but when i am using it in text box for selected geography its giving rank as 1 for each value.Please suggest your opinions.

Thanks!

[tresesco]

Rank function can only(directly) be used in chart expression. However, you can try alternatively like:

=Aggr(Rank(Sum({1} Amount)), Dimension)

PFA