A Pivot question

A

assaf1978

Hi,
I have a pivot with two recurring lines : Budget & Actual. They are 2 values
of the field. They are on top of eachother (as it's supposed to be).
I would like to add another row beneath them that shows the subtraction
between the two (doesn't matter which way).
How do I do that within the pivot table ?

Thanks,
Assaf
 
D

Debra Dalgleish

In the pivot table, select one of the Budget or Actual headings.
On the PivotTable toolbar, click PivotTable>Formulas>Calculated Item
Type a name for the item, such as Diff
Type a formula, e.g.: =Budget-Actual
Click OK
 
Top