formula fill - subtracting results of two Pivot Tables?

[Guest]

Hi,
I have two Pivot Tables and would like to subtract the values of one from
the other.
When I try to go to a blank cell and enter the formula I'm ok but when I try
to use the fill function I get the same result in each cell.
Any suggestions to fill the formula down the column?

Thanks
Bruce

 

[Debra Dalgleish]

You're probably creating a formula with the GetPivotData function, which
may be created when you reference a cell in a pivot table. You can
change this setting, or you can type an equal sign, and type the cell
reference, instead of clicking on the pivot table cell to reference it.

To change the setting, there are instructions here to add the Generate
GetPivotData button to your toolbar. Then, use the button to turn this
feature on or off:

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

 

[Guest]

Thanks Debra

Bruce

You're probably creating a formula with the GetPivotData function, which
may be created when you reference a cell in a pivot table. You can
change this setting, or you can type an equal sign, and type the cell
reference, instead of clicking on the pivot table cell to reference it.

To change the setting, there are instructions here to add the Generate
GetPivotData button to your toolbar. Then, use the button to turn this
feature on or off:

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