Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Thank u Massimo Grossi.
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