Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Pivot table does not calculate quarterly difference across years

Avatar of Sandra Smith
Sandra SmithFlag for United States of America asked on
Microsoft ExcelSpreadsheetsMicrosoft Applications
3 Comments1 Solution592 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Avatar of peter_varian
peter_varian

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers