Rank given a specific user

[Anonymous]

Hi

I am trying to get a rank of a specific user without selecting them in a listbox. For example, if I have the table below

a   20

b   15

c   30

d   10

and I wanted to show the rank of b in a text box, I want to display b = 2. That box should always show the rank of b even if any selections are made.

Thanks!

[sunny_talwar]

Try this:

If(Sum(Sales) > 0, Rank(Sum({1}Sales)))

=Aggr(If(Sum(Value) > 0,  Rank(Sum({1}Value))), Dim)

[Anonymous · Accepted solution]

I figured out what I was trying to do.

Only({<Field={'b'}>} aggr(rank(sum({1}Sales)), Field)

Thanks for your help!

[sunny_talwar]

Awesome. I suggest closing this thread down by selecting correct and helpful answers

Best,

Sunny