How to show the largest possible value in a text object?

[JoeyPob1214]

HI!

How can we show the largest possible value in a text object?

For example:

Customer   | Sales

ABCD            | 500

EFGH            | 700

IJKL               | 300

MNOP           | 1000

so the text box should output : MNOP 1000 something like that. But when for example EFGH become 1100 for the next month, the text object will output EFGH 1100 automatically.

Thanks

[PrashantSangle]

Use FirstSortedValue()

try below
FirstSortedValue(Customer,-Sales)

Regards,
Prashant

[Vengatesh]

Try This:
=FirstSortedValue(Customer,Sales,1)&' - '& Max(AGGR(Sum(Sales),Customer))

[PrashantSangle]

if you want value Value along with customer number
then use
FirstSortedValue(Customer,-Sales)& ' ' & FirstSortedValue(Sales,-Sales)

Regards,

[JoeyPob1214]

what is the meaning of "-" in the sales? if may I ask?

[PrashantSangle]

he used '-' just to add additional string between Customer and Sales .
So your final output will look like
EFGH-1700

[sergio0592]

I think Joey asks for - in your First Sorted Value expression :

FirstSortedValue(Customer,-Sales)& ' ' & FirstSortedValue(Sales,-Sales)

So, here - , it means that the function returns the last (highest) sorted value.

[JoeyPob1214]

hi, why does the Customer name doesn't show up? Thanks