• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

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?
0
ssmith94015
Asked:
ssmith94015
1 Solution
 
Rob HensonIT & Database AssistantCommented:
Are you able to upload a sample file that we can work with?
0
 
peter_varianCommented:
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
 
ssmith94015Author Commented:
That did it!.  Sorry I was away for so long, holidays took their toll.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now