Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a table about the sales,now I want to know who is top 1 order by the total sales.I want to show the Name in a text.
I have use this :=if(Aggr(sum(Sales),name)=max(Aggr(sum(Sales),name)),name)
but it does not work .
Could you tell me how to solve this problem?
May be this:
FirstSortedValue(Name, -Aggr(Sum(Sales), Name))
or
FirstSortedValue(DISTINCT Name, -Aggr(Sum(Sales), Name))
May be this:
FirstSortedValue(Name, -Aggr(Sum(Sales), Name))
or
FirstSortedValue(DISTINCT Name, -Aggr(Sum(Sales), Name))
Hi Sunny,
Thank you very much.You are right.
Hi Sunny Opening the thread again for another scenario example below data have two persons have max(sale), now to show two name in the text box
Hi sunny,
Achieved with the help of rank function, in order to show multiple names have top 1
=concat(if(aggr(rank(sum(Sale)),Name)='1',Name),',')