Pivot Tables - subtract totals

[mmsales]

I created a pivot table from one sheet that included all invoices from 05 & 06. I have Cust/Mfgr/prod in the row fields. I put the ;'idate' and 'amount' in data area. grouped by year. Now I have 3 columns: 2005 sales, 2006 sales, and grand total. I want to subtract 2005 from 2006 totals to get a difference. The only formula available is sum. I tried insert formula but get n/a.
Thanks
Cindy

 

[kjv1611]

Well, it sounds like you want the formula to be something like this:

=(SUM(A1:A10))-(SUM(B1:B10)

Or, assuming maybe row 11 has the total for each column:

=A11 - B11

Or is that way off?

 

[mmsales]

Thanks for the response: I tried it and similar formulas, but I am using a total created by pivot and the 'getpivotdata' comes up and makes the cell absolute ($a$1) and I can't copy down the column.
I tried + then moving to first column, then the - and moving to second total. But I don't want to do this for each row. I have 200+ rows to calculate.

thanks
cindy

 

[kjv1611]

It looks like from what you just posted, that you can fix it this way:

Go into the formula (in the formula bar), and select the portion of text $a$1, and press your "F4" key on your keyboard until the $ signs are gone.

Then, copy the formual down, and see if that works.

I hope this is helpful, and not leading you on a wild goose chase!