LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculated Field and Calculated Item in Pivot Table Fred Smith Excel Discussion (Misc queries) 0 March 4th 07 08:15 PM
pivot table formulas for calculated field or calculated item Vicky Excel Discussion (Misc queries) 3 June 6th 06 05:06 AM
Calculated Field/Item in a Pivot Matt D Francis Excel Worksheet Functions 8 March 1st 06 09:07 AM
Pivot Table Calculated field item Tim Excel Discussion (Misc queries) 1 September 24th 05 12:31 AM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"