Pivot Table - Show difference

[Erika]

I have a pivot table with the fields of year and units. I have the pivot
table displaying Sum of Units for 2008 and sum of unit for 2009 I did to show
the difference between the 2 units when units is one field.

How do I set that up?

 

[Eduardo]

Hi,
You need to add a column (helper) with the formula and then add it to the PT

 

[Erika]

I appreciate your assistance, how do I set up the helper column?

 

[Eduardo]

Hi Erika,
Just need to add one more column in your spreadsheet where you enter the
difference between 2008 and 2009, then when selecting the range of you PT,
add this column to it

 

[Erika]

I apologize for being such a problem but I am still not getting it to work my
spreadsheet looks like this

Month Year Units
1 2008 250
2 2008 225
...............................
1 2009 320
2 2009 300

How do I set up the helper column?

 

[Herbert Seidenberg]

Excel 2007 PivotTable
No helper column needed.
http://www.mediafire.com/file/inzymtezdiy/07_14_09.xlsx

 

[Erika]

Amazing, that worked perfectly thank you all for your assistance.