How can i get a single row

[#1]

Please,

How can i get a single row in a list of sellers, I want show the best seller.

Example:

NAME - SALES

Rodrigo - 500

Bruno - 300

Lucas - 7000

I wanna show only Lucas in a Text Object.

Somebody can help me please??

[Anonymous]

It is easy to implement using FirstSortedValue() function:

=FirstSortedValue(NAME, -SALES)

Regards,
Michael

[manideep78]

Try this, It must work.

=Only({<SALES={"$(=Max(SALES))"}>}NAME)