Problem with Calculated item in Pivot Table

Y

Yogesh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Calculated item in Pivot Table 0
Calculated Item in Pivot table 1
Doughnut Chart linked with the slicer in the pivot table 0
Slicers and Calculated Items in Pivot Table 2
Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Pivot Table cell values 1
Additional columns for Pivot table 0

Top