Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a pivot table that gets populated with sales data from a database. From this i get a column with volume sold per day and sum it as a running total.

My problem is that I want to calculate the rate of change of the sales over time. Is there a way to add a calculated field that bases it's calculations on the running total?

share|improve this question
    
So you do not have access to the source data, is that correct? You need to do work within the confines of a pivot table that is updated by linked data that you cannot alter? – Raystafarian Feb 9 '12 at 13:12
    
@Raystafarian I do have access to the source data. But the aim is to make the data very user friendly for my colleges, some of which are bordering computer illiterate. But you have a good point. If I can do the running total in SQL instead, the problem should be solved. – JonC Feb 9 '12 at 17:15
    
Any updates for us? – Raystafarian Feb 24 '12 at 16:17
    
Yes, I have added an answer to my question. But finally I decided to ditch excel all together. Mainly because excel has a tendency to crash when working with charts. So now I'm exploring RapidMiner to see if that works better for me. – JonC Feb 27 '12 at 9:57
up vote 1 down vote accepted

The best way to handle this that I could figure out was to have the data fetched to an empty sheet as a normal table, instead of directly into a pivot table. I can then do more calculations on the data before turning it into a pivot table.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .