View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JP[_3_] JP[_3_] is offline
external usenet poster
 
Posts: 168
Default 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?