![]() |
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