Hi,
I have a dataset with expenses from last 5 year. Data is like below.
I would like to have the expenses adjust to averages pricechanges per year. So the earlier years are comparable to 2021-prices.
And also the price adjustments are dependent of the type of expenses.
For instans expenses from 2019 should be multiplied with 1,03 if it is salary.
And expensees from 2019 should be multiplied with 1,01 if it is "other".
How to do this in load script?
| type | year | expenses |
| salary | 2019 | 100$ |
| other | 2019 | 145$ |
| salary | 2020 | 200$ |
| other | 2020 | 245$ |
