cancel
Showing results for 
Search instead for 
Did you mean: 

Pivot table over columns formula

tomas_je
Ranger

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

6 REPLIES 6

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.

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.  

 

-- IncortaOne@PMsquare.com --