Pivot Table - Calc Variance

Sleever · Mar 7th, 2002, 11:01 AM

I have a pivot table that accurately reflects actual spending and forecasted spending by account for a series of organizations/departments. I am finding it difficult to insert a calculated field that will show the difference (variance) between the actual and forecast for each month.

The table is laid out as follows – I need to add a column under each month (same level as type) to run this calc.

Month : Type(Act & Fcst)
Organization
Group
Dept

Sleever · Mar 7th, 2002, 11:26 AM

please help!

Mark W. · Mar 7th, 2002, 11:52 AM

Insert a Calculated Item using the formula, =Act-Fcst.

Sleever · Mar 7th, 2002, 12:00 PM

Mark,

When I insert the calculated field (Act-Fcst). It drops the field into a row, not a column. Any ideas?

Sami · Mar 7th, 2002, 12:16 PM

isnt variance the standard deviation squared? i got d maths formula if u want it? im doin A level maths?

Mark W. · Mar 7th, 2002, 12:22 PM

Quote:

On 2002-03-07 11:00, Sleever wrote:
Mark,

When I insert the calculated field (Act-Fcst). It drops the field into a row, not a column. Any ideas?

Don't use a Calculated Field... use a Calculated Item

[ This Message was edited by: Mark W. on 2002-03-07 11:23 ]

Michael Anthony · Dec 4th, 2006, 02:24 PM

Quote:

On 2002-03-07 11:00, Sleever wrote:
Mark,

When I insert the calculated field (Act-Fcst). It drops the field into a row, not a column. Any ideas?

Don't use a Calculated Field... use a Calculated Item

[ This Message was edited by: Mark W. on 2002-03-07 11:23 ]

How do I find the appropriate Calculated Item?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 11:01 AM	#1
Sleever New Member Join Date: Mar 2002 Posts: 5	I have a pivot table that accurately reflects actual spending and forecasted spending by account for a series of organizations/departments. I am finding it difficult to insert a calculated field that will show the difference (variance) between the actual and forecast for each month. The table is laid out as follows – I need to add a column under each month (same level as type) to run this calc. Month : Type(Act & Fcst) Organization Group Dept

Mar 7th, 2002, 11:26 AM	#2
Sleever New Member Join Date: Mar 2002 Posts: 5	please help!

Mar 7th, 2002, 11:52 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Insert a Calculated Item using the formula, =Act-Fcst.

Mar 7th, 2002, 12:00 PM	#4
Sleever New Member Join Date: Mar 2002 Posts: 5	Mark, When I insert the calculated field (Act-Fcst). It drops the field into a row, not a column. Any ideas?

Mar 7th, 2002, 12:16 PM	#5
Sami Board Regular Join Date: Mar 2002 Posts: 122	isnt variance the standard deviation squared? i got d maths formula if u want it? im doin A level maths?