pivot Table -Calculated fields

**sach0025** · 07-09-2007, 11:06 AM

Hi - I am really stuck with a simple issue on my pivot.

I have two columns on my Pivot Table as follows
A. Column A = Estimates on Project from Team A
B. Column B = Estimates on Projects from Team B.

I am interested in calculating the difference between Column A and Column B within the pivot. I know that I can do this by creating a column in the Source Data but I would like to do this within the Pivot Table?

Is it possible to calculate the difference between the two fields within the pivot table? --may be by using Var or VarP functions within the pivot.

please help

Thanks,
Ritu

**NBVC** · 07-09-2007, 11:28 AM

If you view the PivotTable toolbar (View|Toolbars|Pivot Table), then in the Pivot Table drop down within the toolbar, you'll see a Formulas submenu. Select Calculated Field from that submenu. In the dialogue that appears you can build your formula.