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

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