Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Calculated Field/Item in a Pivot | Excel Worksheet Functions | |||
Pivot Table Calculated field item | Excel Discussion (Misc queries) |