Microsoft Excel - pivot table - Asked By usha anu on 15-May-14 06:38 AM

hi ,

i am use one pvoit table data like below  but in this Growth not calculate Qtr1 vs qtr4 i need privious qtr diff % on qtr to qtr.

2009	Amt	Growth
Qtr1	360300
Qtr2	362900	0.72%
Qtr3	365200	0.63%
Qtr4	365100	-0.03%
2010
Qtr1	354600		-0.02876
Qtr2	366000	3.21%
Qtr3	369300	0.90%
Qtr4	365500	-1.03%

Hello Anu,
Can you give us an idea of your source data and the answers that you require.  I assume that the answers that you have shown are what you are getting and they do not meet your requirements.
Regards
Harry

Hello Anu,
I think I worked out what your problem is.  I think the only way to get what you want is to put a calculation of the growth into your original data table and include that in the pivot table as a field value.
Your only other option would be to do away with the year separator and label your quarters uniquely eg 09Qtr1, 09Qtr2 etc.  Then the %Difference from previous will work as you require.
Regards
Harry