I can't insert a calculated item in a pivot table

[Guest]

I'm pretty new to the world of pivot tables.

I can't find a way to get a year on year growth item inserted that reports
in monthly columns.

This is what I have:

Category Tenant Data Year Jan Feb Mar
Clothing TenantA Turnover ($) 2006 100 110 120
2007 105 112
118
TenantB Turnover ($) 2006 90 90 95
2007 91 93
97
Foods TenantX Turnover ($) 2006 1000 1100 1120
2007 1100
1000 1130

This is what I want:

Category Tenant Data Year Feb Mar
Jan
Clothing TenantA Turnover ($) 2006 100 110
120
2007
105 112 118
Year on Year
5% 1.8% -1.6%
TenantB Turnover ($) 2006 90
90 95
2007
91 93 97
Year on Year
1.1% 3.3% 2.1%
Foods TenantX Turnover ($) 2006 1000 1100
1120
2007
1100 1000 1130
Year on Year
10% 9.1% 0.9%

Obviously the actual data is many more records.

My source data looks like this:

Category Tenant Turnover ($) Month Year

I've done this by adding a calculated item to the Year field but it takes a
loooong time to calculate and eventually displays ALL the tenants for each
category with errors for the tenants not belonging to that category

 

[Roger Govier]

Hi

Remove your calculated item.
Click on the PT>Wizard>Layout
Drag Turnover to the Data Area a second time
Double click on Turnover(2) and choose Options
From the dropdown, Select % Difference from
Choose Base Field Year, Base Item (previous) >OK>OK>Finish