Growth Percentages

[tmumaw]

Hello all: I have a pivot table with years across top and weeks down the left side. I need to calculate a % of growth for each week/year combo. How is this accheived? I have tried befores and afters with different results, but not what I am looking for. Example

years 2005 2006 2007

Weeks

01 10 20 30

I need to see the growth between 2005 and 2006, then 2006 and 2007.by week

Thanks
Thom

[#2]

Marking the checkbox "Relative" option is not available for Pivot Tables.

Regards

Eraaj

[bismart · Accepted solution]

Year	2005			2006			2007
Month	Qty	Variance	Var%	Qty	Variance	Var%	Qty	Variance	Var%
01	10			20	10	100%	30	10	50%
02	6			10	4	67%	8	-2	-20%

Variance Expression : (Sum(Qty) - before(Sum(Qty)))

Var% Expression: (Sum(Qty) - before(Sum(Qty)))/before(Sum(Qty))

[tmumaw]

Bismart,

Thank you very much. This was exactly what I was looking for. You have a great day.

Thom

[tmumaw]

Good Morning Bismark,

I have another question for you. I need to do the same thing for customer counts, however this statement does not work any ideas? Thanks in advance.

Thom

(

Count (DISTINCT [Ship To]) - beforeCount (DISTINCT [Ship To]) / beforeCount (DISTINCT [Ship To]

)