Percentage change in Pivot

Hi there - I am trying to show year over year percentage change within a Pivot. I have this as a field in my report, but obviously summing those is not accurate either. I have tried where you double select a metric (in this place the year over year difference) and then make that second selection a calculation, but I'm not getting the result I need. I actually went item by item and tried them all. My Pivot is showing location, 2016 amount, 2015 amount, the year over year difference and then I'd like the last column to show the percentage incr/decr, but I must have something wrong with the settings. I've attached an example if someone could help, I'd appreciate it.

This solution just takes the raw data from 2015 and 2016 as pivot table fields. It then incorporates the following calculated field formula for the YoY Diff field:

Please Login or Register  to view this content.

To get the % Chg the formula is:

Please Login or Register  to view this content.

Here is a copy of your file with the pivot table:
Pivot Table Calculated Fields.xlsx
Check and make sure that the numbers are as you expect, let me know if you have any questions.

When you select one of the cells in the PT you will see a new tab called Pivot Table Tools with a sub tab named options at the top of the sheet. Select options and find the Fields, Items & Sets icon. The first choice under that selection is for Calculated Fields. You can do mathematical operations with any of the existing fields. I think that I understand what you are saying about hard coding. Lets say that you may want to change the second year from 2015 to 2014 and you want the YoY Diff and % Chg fields to adapt accordingly. I don't think that the calculated field will automatically change, although I could be wrong about that. What you may have to do in that situation is to put a formula like I3-J3 in K3 and K3/J3 in L3. If you want to upload a more comprehensive file and some possible PT queries, someone may be able to help in setting it up the way you want.

You're welcome and thank you for the feedback and added reputation. If you have not already, please take a moment to mark the thread 'Solved' using the thread tools link above your first post. Hope that you have a good day.