Pivot table calculation for difference between 2 columns &sources
 

I need to create a difference calculation in my pivot table to calculate the
difference between two data sources for the same time period. Any help is
greatly appreciated!

Data Source
Sum of Jan
Item Desc Jan 06 Jan 07 Difference
Test 1 ABC 9,553 1,000 -8,553

Pivot table calculation for difference between 2 columns &sources
 

In article ,
says...
I need to create a difference calculation in my pivot table to calculate the
difference between two data sources for the same time period. Any help is
greatly appreciated!

Data Source
Sum of Jan
Item Desc Jan 06 Jan 07 Difference
Test 1 ABC 9,553 1,000 -8,553


Once you have created the PivotTable, select it. Then, from the PivotTable
commandbar select PivotTable Formulas Calculated Field... In the dialog
box, name the calculated field and enter the appropriate formula. You can
select an existing field simply by double-clicking it.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions