Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated fields-Pivot tables | Excel Worksheet Functions | |||
multiple items in database | Excel Worksheet Functions | |||
Computing totals for tax and non-tax items | Excel Worksheet Functions | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Excel 2002 -> Problem with calculated fields in Pivottable | Excel Discussion (Misc queries) |