Pivot Table Show Data AS

[Mick]

Hi there,

I am trying to create a calculated field in a Pivot Table
that automatically calculated the difference between two
columns. I am using "Difference From" but when I choose
the base field (as the item to subtract from) I also need
to choose a base item? I do not want to subtract from
one item but rather a base field only? Also when I
choose any base item it returns as NA#?

Any assiatnce would be greatly appreciated.

Regards

Mick

 

[Debra Dalgleish]

To compare one field to another, you can use a calculated field --

From the PivotTable toolbar, choose PivotTable>Formulas>Calculated Field
Type a name for the formula, e.g. Profit
Enter a formula, using the field names in the Fields list, e.g.:
=UnitSell-UnitCost
Click Close