Prev: Need help adding a formula to to cell with conditional formatting
Next: track changes
From: vivi on 1 Feb 2010 10:42
Hi there

Hope someone can help me as this is bugging me for a long time and nobody in
the office could help me!!

Basically I have a data table which i used for pivot, i have actual, budget
and % variance of actual vs budget. In the pivot table, everything is ok
accept the sub variance, instead of giving a variance, in sum up all the
variance and give me a total:

Cost Centre Manager Actual Plan Sum of Variance £ Sum of Variance %
Martin Middleton 0 0 0 0%
Martin Middleton 45 33 (13) -39%
Martin Middleton 27 27 0 1%
John Hollis 6 6 7 1 11%
David Broughton 0 0 0 0%
Overall 78 66 (12) -26%

As you can see the Variance of 66 and 78 is not -26 but i can't get it equal
to 18%

Is there anyway i can do this please?

Thanks

Viv
From: Herbert Seidenberg on 1 Feb 2010 14:11
Excel 2007 PivotTable
Do calculations in PT, not source data.
Two examples, two source styles.
http://www.mediafire.com/file/dy0yn2jme2j/02_01_10.xlsx
 | 
Pages: 1
Prev: Need help adding a formula to to cell with conditional formatting
Next: track changes