View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nick G.
 
Posts: n/a
Default 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