Table with only the "youngest" rows

[#1]

Hi.

I have a data that looks like this:

Omk1	AnlaegID	Date	Att1	Att2	ID	Amount
304	100	01-01-2010	A	AA	1	227
304	100	01-08-2017	B	AA	2	212
304	100	01-09-2018	B	AA	3	228
304	100	01-04-2013	C	BB	4	403
305	110	01-03-2012	A	AA	5	466
305	110	01-04-2013	A	AA	6	307
305	110	01-07-2016	A	AA	7	116
305	110	01-08-2017	B	BB	8	374

(attached excel file with more rows).

I can not change the dataload. How can i make a (pivot)tabel, that only returns the rows, with the youngest date for each uniqe combination of Omk1 and AnlaegID. I the above it would be ID =3 and ID = 8. In the excel file it is ID= 3, 8, 11, 13 and 16.

/Erik

[Gysbert_Wassenaar · Accepted solution]

You can use the firstsortedvalue function. See attached qvw.