In my pivot table I want to subtrack one column from another.

C

chanceygardener

The two columns are totaled and I want the difference. I went to the field
setting and tried to use difference from but that just give me blanks or
errors. Any suggestions?
 
D

Debra Dalgleish

If the columns are different fields, you can create a calculated field
to subtract one from the other. On the pivot table toolbar, choose
PivotTable>Formulas>Calculated Field. Type a name for the field, and
create a formula.
 
E

Excel Enthusiastic

Hi! What if the columns are in the same field? I use in/out in one column in
the data base, and need to find the balance remaining. Any suggestion is
appreciated!
 
D

Debra Dalgleish

Instead of a calculated field, you can use a calculated item
Select the field button for the in/out field and choose
PivotTable>Formulas>Calculated Item
Name the formula, and create the formula, e.g.
=In-Out
to calculate the balance

Or, in the data, enter the Out items as a negative quantity, and the row
total should show the balance.
 
Top