Hello together,
could anybody help me - I need to select pivot table where will be for each CUSTOMER the second ORDER ordered by DATE.
Data would be
CUSTOMER ORDER QUANTITY DATE
A 1 100 5.1.2021
A 2 200 5.3.2021
A 3 100 5.5.2021
A 4 200 5.7.2021
A 5 100 5.9.2021
C 10 100 14.1.2021
C 20 200 14.3.2021
C 30 100 14.5.2021
Result should be
CUSTOMER ORDER QUANTITY DATE
A 2 200 5.3.2021
C 20 200 14.3.2021
Is it possible?
Thank You!
Martin
Bookmarks