Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try with this
Sum({<Year, Sales= {"$(=Max(Sales))"}>}Sales)
May be this:
FirstSortedValue(Customer, -Aggr(Sum(Sales), Customer))