[Solved] Running Sum for ABC Analysis

MacPhotoBikerMacPhotoBiker Member Posts: 60 Contributor II
edited November 2018 in Help

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?

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

Thanks a lot for any advice!


  • Options
    awchisholmawchisholm RapidMiner Certified Expert, Member Posts: 458 Unicorn

    Use the Integrate operator


  • Options
    MacPhotoBikerMacPhotoBiker Member Posts: 60 Contributor II
    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!

Sign In or Register to comment.