Calculated Item in Pivot table

[Yogesh Gupta]

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/yogeshgup.../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.

 

[Debra Dalgleish]

If you're using Excel 2007, you can filter the Row fields so they don't
show amounts equal to zero. That would hide all the extra items that
appear after you create a calculated field.

If you're using an earlier version of Excel, try a 'Difference From'
custom calculation, instead of a calculated item.

http://www.contextures.com/xlPivot10.html