Avatar of Sandra Smith
Sandra Smith
Flag for United States of America

asked on 

Pivot table does not calculate quarterly difference across years

I have a pivot table that does calculate the difference from one quarter to the next within the same year.  However, it will not calculate the difference between quarter 4 of the prior year against quarterly 1 of the next year.  This is a calculated column using the difference from previous based on the date.  how can I get it to calculate the difference across the quarters of consequtive years?
Microsoft ExcelMicrosoft ApplicationsSpreadsheets

Avatar of undefined
Last Comment
Sandra Smith

8/22/2022 - Mon