[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
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!
Find more posts tagged with
Sort by:
1 - 2 of
21
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
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
Use the Integrate operator
regards
Andrew