Adding % Change Column to Excel 2010 Pivot Table??

[puppers]

I am trying to add columns to my Excel 2010 Pivot Table to calculate % change of sales from year to year. The field name is "Year", while the item columns in the field are 2007, 2008, 2009, 2010, and 2011. How do I add a column between the years that will calculate the % change os sales up or down from the previous year?

Any help GREATLY appreciated!!!

Puppers in GA

[dilipandey]

Hi Puppers,

Welcome to the forum.
In Pivot, there is an option where you can show the variance / difference from previous value. I think the way is :- Right click on field -> Field Settings -> Show Values As tab -> and choose the relevant drop down choice... Do little research on this and if still face issue then upload the sample file. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[pilotage]

I tried your recommendation and don't see the options from a right-click in the grand total column. Using XLS 2013

Hi Puppers,

Welcome to the forum.
In Pivot, there is an option where you can show the variance / difference from previous value. I think the way is :- Right click on field -> Field Settings -> Show Values As tab -> and choose the relevant drop down choice... Do little research on this and if still face issue then upload the sample file. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>