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
