Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
[Solved] Running Sum for ABC Analysis
MacPhotoBiker
Member Posts: 60 
Contributor II
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
Thanks a lot for any advice!
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!
0
Answers
Use the Integrate operator
regards
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