Display the Top Customer for the Category in Straight Table

[Chellappan-Pillai]

I need to display the name of the Customer who has the highest SUM(SalesAmount).

Sample Attached.

[rubenmarin]

Hi, you can try with:
Concat(aggr(If(Rank(SUM(SalesAmount),1,1)=1, Name), EnglishProductName, Name), ', ')

[Chellappan-Pillai]

How to get only the first Customer, If there is multiple Customers with same Sum(SalesAmount)?

[rubenmarin · Accepted solution]

To return the first alphabetically:
Minstring(aggr(If(Rank(SUM(SalesAmount),1,1)=1, Name), EnglishProductName, Name))

To return the last alphabetically:
Maxstring(aggr(If(Rank(SUM(SalesAmount),1,1)=1, Name), EnglishProductName, Name))