Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
It is easy to implement using FirstSortedValue() function:
=FirstSortedValue(NAME, -SALES)
Regards,
Michael
Try this, It must work.
=Only({<SALES={"$(=Max(SALES))"}>}NAME)