I am trying to create a formula that calculates a Quarter change from year to
year where the Quarters are in the columns - so i would need to add the
formula to a new row but cant seem to get it to calculate the different years
- is there an IF function that can be used?


Data
Year Qtr 1 Qtr 2 Qtr 3 Qtr 4
2009 $111,814,953 $176,858,096 $81,572,938 $83,166,330
2010 $116,999,566 $195,651,553 $102,976,126 $46,935,333
(formula to calc differences in Qtr's?????)
Grand Total$228,814,519 $372,509,649 $184,549,063 $130,101,663

EXCEL 2007

Hi Carl.

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 67 towards the top of my home page.

I think it gives you what you want.

I have added a Calculated Item to the Pivot Table. I think that this is what
you required.

If my comments have helped please hit Yes.

Thanks.


"Carl" wrote:

I am trying to create a formula that calculates a Quarter change from year to
year where the Quarters are in the columns - so i would need to add the
formula to a new row but cant seem to get it to calculate the different years
- is there an IF function that can be used?


Data
Year Qtr 1 Qtr 2 Qtr 3 Qtr 4
2009 $111,814,953 $176,858,096 $81,572,938 $83,166,330
2010 $116,999,566 $195,651,553 $102,976,126 $46,935,333
(formula to calc differences in Qtr's?????)
Grand Total$228,814,519 $372,509,649 $184,549,063 $130,101,663