Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I would like to add a column to a pivot table that would show the difference between the two other columns. Below is a sample of data and the pivot table I can get to. PrjType.........YR...........hrs 1...............2003............5 1...............2004............3 2...............2003............6 2...............2004............8 1...............2003............7 1...............2003............6 1...............2003............5 1...............2003............7 ........................................____YR____ ___ ProjType......Data...................2003......... 2004 1.............Sum of hrs...............30...........3 ...............Average of hrs2...........6...........3 2.............Sum of hrs............... 6...........8 ...............Average of hrs2...........6...........8 What I would like is to add a column ("Diff") to the right, after "2004" column to show the difference between 2004 and 2003-to look like .......................................___YR____ ProjType......Data...................2003.....2004 ......Diff 1.............Sum of hrs...............30.......3.........-27 ................Average of hrs2.........6........3..........-3 2.............Sum of hrs............... 6.......8...........2 ...............Average of hrs2..........6........8............2 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
pivot table row vs column headings | Excel Worksheet Functions | |||
ability to auto file column(s) on a pivot table | Excel Worksheet Functions | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions |