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

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

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

Hi

Remove your calculated item.
Click on the PTWizardLayout
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) OKOKFinish
--
Regards

Roger Govier


"VicWest" wrote in message
...
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