Calculate Item (Difference of calculated fields)

[JVID]

Hey All,

In Excel 2007, I have calculated fields which take calculates a percentage. I added a variance column but the calculated field in the variance column calculates the the percentage of the variance as opposed to the change.

Any advice or any recommendations?

Thanks,

JV
SDG

 

[Andrew Poulsom]

Can you be a bit more specific please?

 

[JVID]

Does this help

 

[Andrew Poulsom]

Not really. What are those entries outside your pivot table?

 

[JVID]

In Yellow that is what it should be. The items with the divided sign are the calculated fields. VAR column is Z column - B column in each respective number. The issue I have is the Variance of the the calculated fields (which are %'s). The Calculated variance of the calculated items calculates the percent of the change as opposed to the change in the percent %.

Hmmm that sounds confusing but hope you understand.

 

[Andrew Poulsom]

Is this what you want?

Excel 2010
	E	F	G	H	I
1	Row Labels	Sum of Z	Sum of B	Sum of VAR	Sum of VAR%
2	1	100	250	-150	-60.00%
3	2	50	100	-50	-50.00%
4	3	60	20	40	200.00%
5	4	20	80	-60	-75.00%
6	5	10	10	0	0.00%
7	6	60	80	-20	-25.00%
8	Grand Total	300	540	-240	-44.44%
Sheet8