Modify Data in a a chart

[geogou1973]

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.

[chrismarlow]

Hi,

Try Min, Max and FisrtSortedValue, something like;

Cheers,

Chris.