Can I make two different columns subtract while using a pivot tab
 

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?

Can I make two different columns subtract while using a pivot tab
 

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

On Oct 19, 11:54 am, Josh wrote:
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?