Pivot table formulas

[Corby]

I have a pivot table that is linked to an Access db with about 500k records.
On the table I have 4 columns which are all summed as a % of column. I would
like to subtract column 1% from column 4% for the difference. Since these
are all calculated fields I do not know how to calculate this formula.

Thanks in advance for any help.

Corby

 

[Pecoflyer]

I have a pivot table that is linked to an Access db with about 500
records.
On the table I have 4 columns which are all summed as a % of column.
would
like to subtract column 1% from column 4% for the difference. Sinc
these
are all calculated fields I do not know how to calculate this formula.

Thanks in advance for any help.

Corby

Maybe 'this site' (http://www.contextures.com/xlPivot10.html) will hel

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste