Latest 4 last 4 values

[#1]

  How to get last 4  EDT1 field values from this list below  

C1	EDT1
50083633	22/10/2012
50083633	30/01/2013
50083633	16/04/2013
50083633	11/07/2013
50083633	29/11/2013
50083633	13/12/2013
50083633	02/06/2014
50083633	01/07/2014
50083633	02/07/2014
50083633	08/10/2014
50083633	27/01/2015
50083633	01/04/2015
50083633	04/05/2015
50083633	06/05/2015

[#2]

Thank u Massimo Grossi.

[Anonymous]

[MarcoWedel]

If you also need the C1 values corresponding to the last 4 EDT1 values:

firstsortedvalue(C1, -EDT1, 1)

firstsortedvalue(C1, -EDT1, 2)

firstsortedvalue(C1, -EDT1, 3)

firstsortedvalue(C1, -EDT1, 4)

regards

Marco