Opposite of FirstSortedValue

[#1]

Hi,

What is the exact opposite of FirstSotedValue i.e some thing like LASTSortedValue?

Thx

C

[Gysbert_Wassenaar · Accepted solution]

The opposite is the firstsortedvalue too, only you put a - in front of the field/expression you want to sort on.

firstsortedvalue(Customer, Orderdate) gets the customer with the minumum orderdate

firstsortedvalue(Customer, -Orderdate) gets the customer with the maximum orderdate

[er_mohit]

use vlastsortedvalue