G Guest Oct 19, 2007 #1 I am creating a Pivot table and want it to subtract column A from Column B with in the pivot table. Can this be done?
I am creating a Pivot table and want it to subtract column A from Column B with in the pivot table. Can this be done?
J JP Oct 19, 2007 #2 Hello, What you are looking for is called "Calculated Fields". On the PivotTable toolbar, select Formulas|Calculated Field. Name the field and then choose which fields you want to use in the calculation. HTH, JP
Hello, What you are looking for is called "Calculated Fields". On the PivotTable toolbar, select Formulas|Calculated Field. Name the field and then choose which fields you want to use in the calculation. HTH, JP