Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.