Rank should not change on selection

[rupaliqlik]

Dear All ,

I have Person wise data and their ranks, but when I elect any person rank is showing 1 . and I want their actual rank. Please tell me what I should do in this scenario.

Thanks in advance.

[Anil_Babu_Samineni]

You can define {1} operator in set expression. It will give constant even if selection happen

[tajmohamed30]

Hi Rupali,

If you got answer please mark it as answered under actions to close the discussion.

Thanks

Taj

[satishkurra]

Hi

I would suggest using with aggregation as

=Sum(aggr(rank( sum( {$<Name=>} Marks) ), Name))

or

=Min(aggr(rank( sum( {$<Name=>} Marks) ), Name))

or

=Max(aggr(rank( sum( {$<Name=>} Marks) ), Name))