Rate of Change in a Pivot table

[Srushbri]

Hi,

I have individual calls for a call center. I created a pivot table with total volume listed by Date. I have grouped the dates to show this only as months. I would like to have a column showing change of volume month over month but i keep getting an error.

Notes: My Monthly Volume column is calculated by counting the number of calls within a date, skill, etc.
Here is an example of what i would like to see:

Month	Monthly Volume	Change %
Mar	460
Apr	642	39.57%
May	771	20.09%
Grand Total	1873

<tbody>
</tbody>

When I go to Value Field Settings> Show value as>%Difference From i get #N/A. This is probably because i do not have an actual count of volume but a list of each field and simply count each one. Any ideas on how to work around this?

Thank you in advance!

 

[SpillerBD]

I think you're on the right track.
% Difference from....
Base Field: Date
Base Item: (previous)
?

 

[Srushbri]

SpillerBD,

That's not working, I get #N/A.

 

[Srushbri]

A little more info: Each Call entry has an activity ID, start date/time, end date/time, interval (30 min), day of week, week of year. My Axis fields are Year, month(from grouping start date), week of year, day of week, start date, interval. If I remove everything and leave just Year and Month i can use the "%Difference of" with my base field: Month and Base Item: (previous) but I need the other axis fields to filter out calls I don't need. (I.e. calls coming in outside of hours of operation, weeks of the year I want considered, etc.)


Any idea's would be great! If anyone has a way to use the formulas in the pivot table to solve, please let me know! Thank you again!!!

 

[Srushbri]

SpillerBD - thanks so much for the help. You were right in saying the method should help.

I got this to work by showing value as "% Difference From" and selecting Base field: Month and Base Item: Preivous. I had to move all feilds to column and leave only Months in my row labels of my pivot table.

hope this helps soemeone else