Get the dynamic comparable spend based on common value on selected years

[jovendeluna21]

Hello, 

I just want to request any help on how can I create a report that will show the comparable spend = Site Id & Internal Part Number combination between two selected years.

On below example, the Total USD Spend is the total 2024 spend while the Comparable USD Spend is the comparable spend of 2024 compared to 2023 recurring purchases (Site Id & Internal Part Number combination).

I am aiming to have this kind of report that I just did manually in excel. 

I uploaded here the sample data:

https://docs.google.com/spreadsheets/d/1gt14nqorF8fKtCMR8xacnDigtAABsOtC/edit?usp=sharing&ouid=11683...

[jovendeluna21]

Thank you @lbendlin ! Is there a way to make it dynamic? Like let's say on my screenshot, I have 2 year filters and I can compare 2022 to 2024 using the filters. 

[lbendlin]

yes, change the measure to grab the MIN year and then compare to that.

[jovendeluna21]

Hi, I am aiming to add these three metrics and hopefully you can help me to add

[lbendlin · Accepted solution]