1
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?
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 – 2012-02-09T13:12:52.127
@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 – 2012-02-09T17:15:56.720
Any updates for us? – Raystafarian – 2012-02-24T16:17:01.693
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 – 2012-02-27T09:57:45.063