Pivot Table % Growth Calculation

[steve.odom]

I have a pivot table where the source looks like this:

|Company|Quarter|Year|Sales
IBM | 4 | 2005 | 5555
IBM | 4 | 2006 | 6219
APL | 4 | 2005 | 1234
APL | 4 | 2006 | 1800

I'm trying to build a pivot table that will return the quarterly
percent growth for each company, where % growth is defined as the
latest quarters sales over the like quarter a year ago growth. For
example, the pivot table might look like:

Quarter: 4
Company | % Growth
IBM | 12%
APL | 22%

I've been struggling with it.Most of the time, if I change the field
settings to % Difference from I get a bunch of #NA's.

Any suggestions?

Thanks,

Steve

 

[Guest]

One thought: Calculate the quarter-over-quarter growth in your source data.
Then run the pivot table off those calculations?

Dave

 

[Herbert Seidenberg]

If the first 3 columns of your PT
look like this:

Quarter 4
Sum of Sales Year
Company 2005 2006 Growth
APL 1234 1800 45.9%
IBM 5555 6219 12.0%

Add the Growth column this way:
Select the 2006 cell, then from the PT tool bar
Formulas > Calculated Item > Name: Growth
Formula: =('2006'-'2005' )/'2005'
Format the result as Percentage.

 

[steve.odom]

Thanks for both responses. It seems like I will have to add a growth
column. I was trying to do it without going down that route, but it
seems like the easiest (only?) way.

Steve