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...