Calculated Item in Pivot table

  • Thread starter Thread starter Yogesh Gupta
  • Start date Start date
Y

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.
 
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
 
Back
Top