A calculated item gives unwanted changes to my pivot table

G

Guest

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?
 

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

I can't insert a calculated item in a pivot table 1
Calculated Item causes undue repitition in pivot table 2
Average of % in pivot table 1
Pivot table, IF function, calculated item versus calculated field 1
Pivot Table Calculated Item 1
Calculated Field in Pivot Table 1
Countif or sumif for cumulative sums,pivot table & chart 2
Pivot Table Question - a puzzler 1

Top