Get the last value from FirstSortedValue function

[#1]

Hi,

I want to get the last order Date for each customer using the FirstSortedValue function

For example

Name      OrderDate

miguel     21/01/2014

Jose       30/11/2014

Carlos     13/01/2014

Miguel     21/11/2014

the output data look like

Name     OrderDate

Miguel     21/11/2014

Jose       30/11/2014

Carlos     13/01/2014

Anyone can help me?

[JonnyPoole]

This should work in a chart expression:

FirstSortedValue( Date#(OrderDate,'DD/MM/YYYY'), Date#(OrderDate,'DD/MM/YYYY'))

[#3]

I just solved.

Only had to add symbol - to parameters and it works correctly.