extract User name based on the top sales

[renjithpl]

Hi All,

I want to get the user name based on who has got the top sales.

My expression is Sum(Sales). and there are 500 User Names,

How can i get only the name in the text box?

Thanks

Ranjith

[pat_agen · Accepted solution]

hi,

try something like this:

=only(if(aggr(rank(Sum (Sales)),UserName)=1,UserName))