Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A calculated item gives unwanted changes to my pivot table
I am rephrasing an earlier question. I have a pivot table with fields:
Tenant Category (e.g. Clothing, Gifts, etc); Tenant Name (StarBucks, Woolworths, etc); Turnover (data); Year (2006, 2007 - in row fields); Month (Jan, Feb, Mar, etc - in column Fields). When I insert a calculated item in the Year field calculating year on year growth in turnover for each tenant for each month column it takes VERY long to calculate and it lists ALL the tenants in each category irrespective of whether that tenant belongs to that category or not and shows values (error values for non-applicable tenants) for ALL tenants under each category. Can this be fixed? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
A calculated item gives unwanted changes to my pivot table
Instead of using a calculated item, perhaps you can use a custom
calculation to show the difference. There are instructions he http://www.contextures.com/xlPivot10.html VicWest wrote: I am rephrasing an earlier question. I have a pivot table with fields: Tenant Category (e.g. Clothing, Gifts, etc); Tenant Name (StarBucks, Woolworths, etc); Turnover (data); Year (2006, 2007 - in row fields); Month (Jan, Feb, Mar, etc - in column Fields). When I insert a calculated item in the Year field calculating year on year growth in turnover for each tenant for each month column it takes VERY long to calculate and it lists ALL the tenants in each category irrespective of whether that tenant belongs to that category or not and shows values (error values for non-applicable tenants) for ALL tenants under each category. Can this be fixed? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Item | Excel Discussion (Misc queries) |