Pivot Table - Show difference

E

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?
 
E

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
 
E

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top