Excel: Multiple calculations on data in pivot-table

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?

JonC

Posted 2012-02-09T09:09:00.100

Reputation: 121

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

Answers

1

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.

JonC

Posted 2012-02-09T09:09:00.100

Reputation: 121

Asked: 2012-02-09T09:09:00.100

Viewed: 809 times

Active: 2012-02-27T09:53:36.923