Prev: Some rules about Vlookup
Next: Calculating total amount in a Pivot Table
From: Yogesh on 26 Jan 2010 03:05
I am using Calculated Item (Not a Calculated Field) in a Pivot table
to calculate variance in Budget and Actual figures. Though this is
working fine and I am getting the variance calculation properly.
However the page filter is not showing proper results.

Once I am using page fileter to see data for a particular geography,
it keep on showing the claculated items for data which is not related
to geography as per page filter.

My file is available at the following link, I am not sure of the
mistake I am making in this Pivot Table

http://sites.google.com/a/yogeshguptaonline.com/resources/excel-formulas/CalculatedItemProblem.xls?attredirects=0&d=1

In this file Pivot table is filtered on Geography "East" , however the
report is still showing the calculated item "Variance" for states that
does not belong to geography "East"

Please help me to resolve this problem.
From: Herbert Seidenberg on 26 Jan 2010 23:36
Excel 2007 PivotTable
Show Budget-Actual without formulas or calculated anything.
Solves problem of extra empty fields with report filter.
http://www.mediafire.com/file/mm0mynjtwzy/01_26_10.xlsx
 | 
Pages: 1
Prev: Some rules about Vlookup
Next: Calculating total amount in a Pivot Table