Calculating percent change in Excel Pivot Table

1
votes

Using standard Excel 2010 I am trying to calculate percent change from 2013 to 2014 and put that in a column after grand total.

The formula I am trying to use is (2013 - 2014) / 2013

I have tried Calculated Field but that hasn't worked, and I can't do Calculated Item since I grouped my dates to show in years instead of days.

enter image description here

This is what the source data looks like :

enter image description here

Any help is appreciated!

1
excelexcel-2010pivot-table
Yes, that is. I want to see the negative numbers. Do you have a different formula in mind? - Adjit
This looks helpful: youtube.com/watch?v=XGRX843rzcI - Jeff Anderson
@pnuts no worries. We are all guilty of that ;) - Adjit
@user2348184 yeah, but wasn't for percent change, just for percent - Adjit
@pnuts updated question with source data - Adjit

1 Answers

2
votes

Assuming you now have Sales in the value field and Year in the column field

Add Sales to the value field again

Click the drop down for your second Sales

Go to "Value Field Settings"

Go to show "Show Value As" in the tab

"Show Values As" scroll to "% Difference From"

Base Field is Year

Base item is Previous