A Pivot question

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

Debra
Mon May 12 11:47:36 CDT 2008

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

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