Pivot table formulas
 

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

Pivot table formulas
 

Corby;221349 Wrote:
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

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61010