Hi Jelena ,
Based on you what you explained here , you can create a calculated field such as
Column - Year = concat('Column ’ , toString(Year))
And what you select on data , values can be passed through parameter and filter for last 3 years ( in this example I have sales data for 2021 and 2018 and showing last 3 years in table)
Your column on pivot table can be rendered dynamically based on year in selected date.
- pDate is parameter used
This is how it would be achieved , Hope this helps your use-case
