Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calc % change by periods
Is there a way to incorporate a calcualted field in a pivot table report that
will find the % change in, say, sales or units from period to period? My pivot looks like this: sales units 2003 2004 2005 2003 2004 2005 I would like to add an additional sales and units metric for the period 2003-2004 and 2004-2005 for each. I am not sure if I have to create a Calculate Item for each period I would like to find. Any help would be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find function | Excel Worksheet Functions | |||
Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) |