Displaying field associated with a set

[TomHouseman]

Assume I have order data - order#, customer, date, order value, etc.

How can I display the customer who gave the order with the highest value.  Listing a KPI with the max(ordervalue) is simple enough, but in the title, I would like to display the customer who placed that order.

[sunny_talwar]

Try this @TomHouseman 

FirstSortedValue(Customer, -ordervalue)

or this if you want the Customer by Sum(ordervalue)

FirstSortedValue(Customer, -Aggr(Sum(ordervalue), Customer))

[Chanty4u]

can you try this

=Max(Aggr(Sum(OrderValue), Customer))