Calculated items
 

Hi,

I have a very simple table, with 5 columns, Regions, Country, Product, Year
and Sales. I create a pivot table where I have the years in columns like a
crosstable. Currently, I'm only showing Region in the Rows. Now, Between Each
Year column, I would like to have the increase in percents between 2 years -
I show actual sales for 04 in one column, next column growth and next column
actual 05 and so on. This I've done with Calculated Items. But I have two
problems; 1) for the total, it seems as Excel calculates the sum of
percentages rather than calculate the growth between the totals. 2) If I pull
down the Country field, something very interesting is happening as Excel
repeats all countries available in all Regions.
Could someone explain please?
Thanks,
Per