Calculate % of Change with in a Pivot

[scrasch]

I am trying to add a % change calculation to a pivot table. Example Columns are Jan, Feb, Mar and rows are Apples, Pears, and grapes. I want it to auto calculate for each row the % change from Jan to March…..=(JanApples – MarApples)/MarApples


Any suggestions on doing it with in the pivot?


scrasch

 

[inbp]

Dear Scrasch


i think you should use calculated field in pivot

 

[keymaster]

@Scrasch...


You can use % of calculation option to find out how much % of JAN sales are done in March. This is not exactly what you wanted, but almost similar.

 

[keymaster]

Ooops.. I am wrong.


You can do this easily by using "% difference from..." value field setting.


Follow below steps:

[list type=decimal]
[*]Add Sales to pivot values
[*]Right click on it, goto value field settings
[*]Go to show values as...
Choose % difference from
Specify Jan as base
Click ok
[/list type=decimal]