Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following data
Valid Date | Item | Supplier | Cost Price |
23/12/2019 | 1392178 | 54963 | 2,41 |
01/02/2021 | 1392178 | 54963 | 1,69 |
13/07/2021 | 1392178 | 54963 | 1,69 |
and i want to create a chart that in one line have the following image
Item | Supplier | Valid Date | Cost Price | Valid Date | Cost Price |
1392178 | 54963 | 23/12/2019 | 2,41 | 13/07/2021 | 1,69 |
How can i manage this. I want to have the item in the specific supplier in one line , and the max date of changing the cost price with the date and the price and the date with the price of the max date before of this date.
I have the 13/07/2021 that is the max date that the cost price has changed and i want also to have the max date before of this date and price that the price is different from the max date that is 23/12/2019.
Thank you in advanced.
Hi,
Try Min, Max and FisrtSortedValue, something like;
Cheers,
Chris.