Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
try something like this:
=only(if(aggr(rank(Sum (Sales)),UserName)=1,UserName))
hi,
try something like this:
=only(if(aggr(rank(Sum (Sales)),UserName)=1,UserName))