Running percentage change in a pivot table?

[Jay T]

Hey Guys!

I've seen a few close examples but not an exact match for my task. Hoping someone can steer me in the right direction with this one. I have data in a pivot table and would like to get % change from one row to the next. I can accomplish this in the data table but would rather take care of it in a pivot table if at all possible. Below is a quick diaphragm to help illustrate what I have in mind (i.e. % change from day to day for multiple columns) Anyone have any ideas?

Date|Value1|Value1 % Change|Value2|Value2 % Change
10-10-13|2| |4| |
10-11-13|4|100%|6|50%
10-12-13|6|50%|18|200%

[Jay T]

Got it! Just an FYI in case anyone else needs something similar:

Set your value field setting (of the field you're interested in) to 'Show Value As' then '% difference from' with the base set on 'Date' & the item set on 'previous'.

To summarize, this gives you % change from day to day on whatever field you are tracking.