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

G

Guest

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculation based on 2 columns 3
Pivot table 1
Referencing a pivot tables Grand Totals Column 1
Pivot Table Set Up 2
Question on the occupied field of the pivot table in excel spreadsheet 0
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot table--and adjacent columns 1
Derived Columns in Pivot Table 1

Top