RapidMiner

RapidMiner

[Solved] Running Sum for ABC Analysis

Regular Contributor

[Solved] Running Sum for ABC Analysis

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!
 
2 REPLIES
Super Contributor

Re: Running Sum for ABC Analysis

Hello

Use the Integrate operator

regards

Andrew
Regular Contributor

Re: [Solved] Running Sum for ABC Analysis

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