09-27-2022 04:21 AM
I have pivot table with years in columns, how can I calculate Y/Y diff inside the table?
Solved! Go to Solution.
09-27-2022 08:21 AM
I tried similarly but this is not working, because data in Pivot table are filtered already only for the year in the column, so second part of the formula returns 0.
09-27-2022 08:50 AM
Yes. I removed the year filter. I also added a day-number-of-year ( on 9/27 the value is 270 ) filter so that e.g. 2022 would include up to today and so would 2021.
Another approach is to build an MV with current year, past year, YoY difference as separate columns.