Get Top Customer Name based on Sales

[#1]

Hello Community,

I am trying to display the top result from Customer field based on maximum value in Sales field; in this case (refer below table), I want to display Customer "XYZ" in a text box. How can I achieve this?

Also Note: Below Values are dynamic and will change

Customer	Sales
ABC	30
XYZ	100
QWE	25
ASD	20
OPL	20

Thanks,

[fvelascog72 · Accepted solution]

Hi,

Try this in the text Object:

=Concat({<Sales={'$(=Max(Sales))'}>}Customer, ',')

[buzzy996]

try tis,

[#4]

It worked!! Thanks Federico!!

=only({<sales={'$(=Max(sales))'}>}customer) --> returns only 1 value...

but

=concat({<sales={'$(=Max(sales))'}>}customer) --> return all possible value

eg: if i wanted customers doing low or least sales..then I will use concat in my case since it has two values.

=concat({<sales={'$(=Min(sales))'}>}customer) --> returns ASD,OPL

[sushil353]

Try:

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

[fvelascog72]

Yes, you are right,

First I posted only, but later I edit post with concat option.

Regards

[#7]

This works as well!!

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