add a column to a pivot table that would show the difference between 2 other Columns
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
|