ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calc % change by periods (https://www.excelbanter.com/excel-discussion-misc-queries/65534-calc-%25-change-periods.html)

Nick G.

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


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com