View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sg[_2_] sg[_2_] is offline
external usenet poster
 
Posts: 1
Default Need Help Using Calculated Field or Item in Pivot Table

Hi there - am having difficulty figuring out the pivot table Calculated
Field and Calculated Item features in Excel 2003.

My pivot table is setup as follows:
Name - Item - Month1 - Month2 - Month3 - Month4 - Month5 -
Month6 - Total
* Data is sum of revenue

For this example:
Month1, Month2 and Month3 is considered "BASE"
Month4, Month5 and Month6 is considered "CURRENT"
(both 'base' and 'current' are variables, so they will have to be re-defined
each month)

What I want to do:
Is create a column which calculates "INCREMENTAL"
Incremental = Current - Base

In the end, what i would like to have is a pivot that looks similar to this:
Name - Item - Month1 - Month2 - Month3 - Month4 - Month5 -
Month6 - Incremental
or
-------------BASE------------ ----------CURRENT--------
Name - Item - Month1 - Month2 - Month3 - Month4 - Month5 -
Month6 - Incremental

I have tried using grouping to group the Base months, and the Current
months.
For the life of me, i can't figure out how to do this.

Would appreciate your kind assistance!