Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Problem with Calculated item in Pivot Table

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/yogeshgupt...edirects=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.


--
Yogesh Gupta
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Calculated item in Pivot Table Yogesh[_2_] Excel Discussion (Misc queries) 1 January 27th 10 05:36 AM
Calculated Field and Calculated Item in Pivot Table Fred Smith Excel Discussion (Misc queries) 0 March 4th 07 09:15 PM
pivot table formulas for calculated field or calculated item Vicky Excel Discussion (Misc queries) 3 June 6th 06 06:06 AM
Pivot Table Calculated Item SamBayer1957 Excel Discussion (Misc queries) 1 August 11th 05 11:27 PM
Pivot Table Calculated Item Erin Searfoss Excel Discussion (Misc queries) 2 February 9th 05 04:11 AM


All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"