maximum value

[#1]

Hi Experts,

i have to find the customer who has done maximum sales this year and i need to display in text box.

Can somebody help me with the expression please

[Anil_Babu_Samineni]

Try with this

Sum({<Year, Sales= {"$(=Max(Sales))"}>}Sales)

[sunny_talwar · Accepted solution]

May be this:

FirstSortedValue(Customer, -Aggr(Sum(Sales), Customer))