| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Show difference
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Show difference
Hi,
You need to add a column (helper) with the formula and then add it to the PT "Erika" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Show difference
I appreciate your assistance, how do I set up the helper column?
"Eduardo" wrote: Hi, You need to add a column (helper) with the formula and then add it to the PT "Erika" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Show difference
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" wrote: I appreciate your assistance, how do I set up the helper column? "Eduardo" wrote: Hi, You need to add a column (helper) with the formula and then add it to the PT "Erika" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Show difference
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? "Eduardo" wrote: 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" wrote: I appreciate your assistance, how do I set up the helper column? "Eduardo" wrote: Hi, You need to add a column (helper) with the formula and then add it to the PT "Erika" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Show difference
Excel 2007 PivotTable
No helper column needed. http://www.mediafire.com/file/inzymtezdiy/07_14_09.xlsx |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Show difference
Amazing, that worked perfectly thank you all for your assistance.
"Herbert Seidenberg" wrote: Excel 2007 PivotTable No helper column needed. http://www.mediafire.com/file/inzymtezdiy/07_14_09.xlsx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Difference Columns | Excel Discussion (Misc queries) | |||
| Pivot table % Difference From (previous) | Excel Discussion (Misc queries) | |||
| Pivot Table Subtotals - Difference | Excel Worksheet Functions | |||
| Difference between Averages in a Pivot Table | Excel Worksheet Functions | |||
| add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Linear Mode
