Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rank given a specific user

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!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I figured out what I was trying to do.

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

Thanks for your help!

View solution in original post

3 Replies
sunny_talwar

Try this:

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

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

Capture.PNG

Anonymous
Not applicable
Author

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