Pivot Table calculate field - variance - on running sum

[mattcoll]

I have the following need which must be not uncommon, but seems impossible to do.

I have the following data.....

Excel 2010
	E	F	G	H
4	ref0	ref	val	bud
5	a	a	12	15
6	a	b	24	15
7	b	c	35	15
8	b	d	12	15
9	c	e	7	15
10	c	f	10	15
11	d	g	10	15
Sheet7 (2)

I need to compare the value to budget and calculate both the variance as a 'value' difference, and a 'percent' difference, AND have this within the pivot table i.e. not outside the pivot table.

So, i have two caluclated fields var=bud-val, and varpc=var/bud

But, wait, i also want to present the val, bud, var as running totals on my first group (ref0), and have the percent difference understand this.

However it doesn't seem to, with the following results. Essentially the 'percent' difference works on the 'No calulation' figures.

No matter what i try, i cannot figure this out.

Any suggestions would be helpful.
Thanks.

This is what i get - with the 'Expected' column being a manual calulation, and the orange items where the calculation is wrong - IMHO.

Excel 2010
	J	K	L	M	N	O	P	Q
13						No Calculation	Running Total In	Not in Pivot
14			Values					Expected
15	ref0	ref	Sum of val	Sum of bud	Sum of var	Sum of varpc	Sum of varpc2
16	a	a	12	15	-3	-20.00%	-20.00%	-20%
17		b	24	15	9	60.00%	60.00%	60%
18	a Total		36	30	6	20.00%	20.00%	20%
19	b	c	35	15	20	133.33%	133.33%	133%
20		d	12	15	-3	-20.00%	-20.00%	-20%
21	b Total		83	60	23	56.67%	76.67%	38%
22	c	e	7	15	-8	-53.33%	-53.33%	-53%
23		f	10	15	-5	-33.33%	-33.33%	-33%
24	c Total		100	90	10	-43.33%	33.33%	11%
25	d	g	10	15	-5	-33.33%	-33.33%	-33%
26	d Total		110	105	5	-33.33%	0.00%	5%
27	Grand Total					4.76%
Sheet7 (2)