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?
Sandra SmithRetiredAsked:
Who is Participating?
 
peter_varianConnect With a Mentor Commented:
You'll most likely have the situation as in my example 1. The changing year going from FY13 to FY14 prevents Q1-14 to be compared to Q4-13. So you'll have to concatenate the year with the quarter like I did in example 2.Growth-vs-prev-quarter.jpg
0
 
Rob HensonFinance AnalystCommented:
Are you able to upload a sample file that we can work with?
0
 
Sandra SmithRetiredAuthor Commented:
That did it!.  Sorry I was away for so long, holidays took their toll.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.