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

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

assaf1978 wrote:
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 ?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html