The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

[Solved] Running Sum for ABC Analysis

MacPhotoBikerMacPhotoBiker Member Posts: 60 Contributor II
edited November 2018 in Help
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!
 

Answers

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

    Use the Integrate operator

    regards

    Andrew
  • 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!

    MacPhotoBiker
Sign In or Register to comment.