Highest Rank

[amars]

Hi all,

While using Rank Function, I wish to find out the last rank in the row. i.e.

User     Score     Rank(Total Sum(Score))

abc       55          3

pqr        22          4

xyz       71          2

anz       91          1

Now I wish to find out 4 for each row of the Chart Table . i.e. desired output

User     Score     Rank(Total Sum(Score))     highest Rank

abc       55          3                                       4

pqr        22          4                                       4

xyz       71          2                                       4

anz       91          1                                       4

Kindly suggest how can I achieve this.

Thanks in advance

[michael_maeuser]

bottom(rowno())

[CELAMBARASAN · Accepted solution]

Hi,

Try with this

Max(Total Aggr(Rank(Sum(Score)),User))

[jjordaan]

Try This Rank(-Sum(Field))

[vikasmahajan]

=AGGR(Rank( Total(Rank(Total Sum(Score)) , USER,SCORE)

Vikas