Pivot table over columns formula

[tomas_je]

I have pivot table with years in columns, how can I calculate Y/Y diff inside the table?

[tomas_je]

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.

[RADSr · Accepted solution]

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.