I have data with Date column, Total Cost column, etc with data from 2016 to 2023 I want to create a Master measure for Inflation rate to compare % change of total cost for the latest year to the previous year and so forth (like % change for 2023 to 2022, 2022 to 2021, 2021 to 2020, 2020 to 2019, 2019 to 2018, etc) and plot a graph of inflation rate vs year. I tried to use this formula but it return only one value for inflation rate for 2023 to 2022. ((sum({$<Year={"$(vMaxYear)"}>} TOTALCOST) - sum({$<Year={"$(vPreYear)"}>} TOTALCOST)) / sum({$<Year={"$(vPreYear)"}>} TOTALCOST)) * 100
I want to plot something like Inflation rate vs Years(it can include or exclude months, either way its because I have a filter months)
