Need a help urgently. I have a dataset like below.
What I need to show in a table is like below
Basically I want to fetch for each material's cost for the year's max purchase date and compare the cost with its latest purchase date cost.
For ex: for material ABC the latest cost is 200 of purchase date 20/05/2018 and this cost needs to be compared with last year's last purchase date cost. i.e cost will be 150 for purchase date 16/08/2017. Now I need to compare the cost growth f these data which will be 33%.