How to Add a Calculation to a Pivot Table ?

[Guest]

This seems easy enough - and have figured out a quick & dirtly way - but need
to get it into a formula.

'Created a pivot table and need to calculated the difference between two
columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
what's the increase?

 

[Barb Reinhardt]

Enter your formula in an adjacent column. It should automatically fill in
the pivot table functions you need.
At least that's what I've seen.

 

[Guest]

Hi, Barb -
Oh - I see. I need to type in the formula instead of mouse click cell J3
minus H3

Thanks for your response!

 

[Debra Dalgleish]

You can use the 'Difference From' custom calculation. There's an example
here, using two years. You could use days instead:

http://www.contextures.com/xlPivot10.html#DiffFrom

And there are instructions here for turning off the Generate
GetPivotData feature:

http://www.contextures.com/xlPivot06.html