Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=FirstSortedValue(distinct [Person],-[Sales])
This expression returns the top sales person based on the Highest Sales value, but I want to retrieve the person with the highest Sum(Sales) value.
e.g.
Person Sales
Rob 6000
John 7000
Rob 5000
John 1000
My expression returns John based on the highest sale 7000. Whereas I expect Rob to be returned because his sum is 11000. Please help.
Thanks,
Ram
may be like this
=FirstSortedValue([Person], Aggr(-Sum([Sales]), Person))
Have you tried this?
Edit:
Expression corrected: FirstSortedValue(Person, -Aggr(Sum(Sales),Person))
may be like this
=FirstSortedValue([Person], Aggr(-Sum([Sales]), Person))
HI
Try like this
I think so,
= FirstSortedValue(Person, -Aggr(Sum(Sales),Person))
Thanks to both of you. It works!!