Top Rank Chart Label

[AC3]

I have a chart which plots the top ranking Customer over 2 days by hour. 

The Expression used is: Sum({1<customer= {"=aggr(rank(sum(sales)), customer) = 1"}> } sales)

I'd like the Expression Label to be the customer with rank=1.  I've tried this if(rank(sum(sales))=1,customer) but it's returning nulls. 

Appreciate any help!

[Gysbert_Wassenaar · Accepted solution]

Try =only({1<customer={"=rank(sum(sales))=1"}>} customer)

[#3]

try below:

Sum({1<customer= {"$(=aggr(rank(sum(sales)), customer) = 1)"}> } sales)

[mayankraoka]

Did you try using firstsorted value function and aggr that and to display

it in descending order use - sign

[AC3]

Awesome, thank you!!