Is there a way to format a pivot table setup to calculate a variance in place of the Grand Total colum ? - eg TY vs LY comparison analysis.tal column.
WEEK NO 2009 2010 Grand Total
1 4313.12 4313.12
2 4316.88 4316.88
3 5513.01 5513.01
4 4728.37 4728.37
5 4438.43 4438.43
6 5517.71 5517.71
7 3002.5 3002.5
8 4312.07 4312.07
9 3975.16 3975.16
10 6466.6 4320.78 10787.38
11 6368.04 6368.04
12 6368.04 1790.71 8158.75
WEEK NO 2009 2010 Grand Total
1 4313.12 4313.12
2 4316.88 4316.88
3 5513.01 5513.01
4 4728.37 4728.37
5 4438.43 4438.43
6 5517.71 5517.71
7 3002.5 3002.5
8 4312.07 4312.07
9 3975.16 3975.16
10 6466.6 4320.78 10787.38
11 6368.04 6368.04
12 6368.04 1790.71 8158.75