Show Values As Different From (Possible Pivot Table Solution)

[MikeL]

Hello,
Source Data is:

Excel 2007
	A	B	C
1	President	Month	Amount
2	Adams	May	170
3	Adams	June	150
4	Bush	May	130
5	Bush	June	160
6	Obama	May	175
7	Obama	June	165
Sheet1

Cell Formulas
Range	Formula
A1	President
A2	Adams
A3	Adams
A4	Bush
A5	Bush
A6	Obama
A7	Obama
B1	Month
B2	May
B3	June
B4	May
B5	June
B6	May
B7	June
C1	Amount
C2	170
C3	150
C4	130
C5	160
C6	175
C7	165

I created a pivot and would like to show the variance to a fixed value ie F8 and G8

Excel 2007
	E	F	G	H
1	Sum of Amount	Column Labels
2	Row Labels	May	June	Grand Total
3	Adams	170.00	150.00	320.00
4	Bush	130.00	160.00	290.00
5	Obama	175.00	165.00	340.00
6	Grand Total	475.00	475.00	950.00
7
8		160	155
Sheet1

Cell Formulas
Range	Formula
E1	Sum of Amount
E2	Row Labels
E3	Adams
E4	Bush
E5	Obama
E6	Grand Total
F1	Column Labels
F2	May
F3	170
F4	130
F5	175
F6	475
F8	160
G2	June
G3	150
G4	160
G5	165
G6	475
G8	155
H2	Grand Total
H3	320
H4	290
H5	340
H6	950

Ideally, the result would be

Excel 2007
	J	K	L
1	Sum of Amount	Column Labels
2	Row Labels	May	June
3	Adams	10	-5
4	Bush	-30	5
5	Obama	15	10
6
7
8		160	155
Sheet1

Cell Formulas
Range	Formula
J1	Sum of Amount
J2	Row Labels
J3	Adams
J4	Bush
J5	Obama
K1	Column Labels
K2	May
K3	10
K4	-30
K5	15
K8	160
L2	June
L3	-5
L4	5
L5	10
L8	155