Solved

Pivot table does not calculate quarterly difference across years

Posted on 2014-12-16
3
223 Views
Last Modified: 2015-01-08
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
Comment
Question by:ssmith94015
3 Comments
 
LVL 33

Expert Comment

by:Rob Henson
ID: 40504703
Are you able to upload a sample file that we can work with?
0
 
LVL 1

Accepted Solution

by:
peter_varian earned 500 total points
ID: 40506683
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
 

Author Closing Comment

by:ssmith94015
ID: 40538393
That did it!.  Sorry I was away for so long, holidays took their toll.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question