Pages: [1]
  Print  
Author Topic: [Solved] Running Sum for ABC Analysis  (Read 2106 times)
MacPhotoBiker
Jr. Member
**
Posts: 56


WWW
« on: June 12, 2013, 12:30:42 AM »

Hi,

I'm trying to perform an ABC Analysis (e. g. "'A' customers are those that generate 50 % of revenue, 'B' customers the next 25 %, and 'C' customers the remaining 25 %).

In order to do so, I'm calculating the sales per customer, and sort the list descending by sales, that's simple. But how can I calculate the Running Sum on the sales values?

Example

Customer   Sales  Running Sum
Cust1    1000       1000
Cust2     700       1700
Cust3     300       2000
Cust4     250       2250


Thanks a lot for any advice!
  
« Last Edit: June 12, 2013, 08:09:01 AM by MacPhotoBiker » Logged

MacPhotoBiker
Just do your Core Business. We do the rest.
awchisholm
Sr. Member
****
Posts: 350


WWW
« Reply #1 on: June 12, 2013, 05:53:28 AM »

Hello

Use the Integrate operator

regards

Andrew
Logged

MacPhotoBiker
Jr. Member
**
Posts: 56


WWW
« Reply #2 on: June 12, 2013, 08:12:02 AM »

Hi Andrew,

thank you very much, that's all I needed!

(Actually I even realised that I had forgotten to install the "Time Series" extension which provides the Integrate operator).

Thanks a lot for your help!

MacPhotoBiker
Logged

MacPhotoBiker
Just do your Core Business. We do the rest.
Pages: [1]
  Print  
 
Jump to: