Forum Discussion
ABC Curve
Hi everyone,
I have the spread sheet below to calculate the ABC curve, the calculation should show analyse per month and local. Could you help me?
| Date | Local | Product | Qty |
| 01/01/2023 | San Diego | A1 | 15 |
| 01/01/2023 | San Diego | A2 | 30 |
| 01/01/2023 | San Diego | A3 | 55 |
| 01/01/2023 | San Diego | A4 | 20 |
| 01/01/2023 | San Diego | A5 | 5 |
| 01/01/2023 | San Diego | A4 | 20 |
| 01/01/2023 | San Diego | A5 | 5 |
| 01/01/2023 | San Diego | A4 | 20 |
| 01/01/2023 | San Diego | A5 | 5 |
| 01/01/2023 | Los Angeles | A1 | 15 |
| 01/01/2023 | Los Angeles | A2 | 30 |
| 01/01/2023 | Los Angeles | A3 | 55 |
| 01/01/2023 | Los Angeles | A4 | 20 |
| 01/01/2023 | Los Angeles | A5 | 5 |
Result expected
| Local | Product | Qty | % | %Acumulado | Curva |
| San Diego | A4 | 60 | 34% | 34% | A |
| San Diego | A3 | 55 | 31% | 66% | A |
| San Diego | A2 | 30 | 17% | 83% | A |
| San Diego | A5 | 15 | 9% | 91% | B |
| San Diego | A1 | 15 | 9% | 100% | C |
| 175 | |||||
| Local | Product | Qty | % | %Acumulado | Curva |
| Los Angeles | A3 | 55 | 44% | 44% | A |
| Los Angeles | A2 | 30 | 24% | 68% | A |
| Los Angeles | A4 | 20 | 16% | 84% | A |
| Los Angeles | A1 | 15 | 12% | 96% | C |
| Los Angeles | A5 | 5 | 4% | 100% | C |
| 125 |
Hello William_Moreno
output :
kindly download the solution from here :
https://drive.google.com/file/d/1gp5pn_u3FiURHznIyN4ln-uXHBRT8kkc/view?usp=sharing
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
3 Replies
Hello William_Moreno
output :
kindly download the solution from here :
https://drive.google.com/file/d/1gp5pn_u3FiURHznIyN4ln-uXHBRT8kkc/view?usp=sharing
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠Hi Daniel29195 thanks a lot for answer me! If it is possible, Could you develop this solution in calculate column, not as measure,. I need a static calculation, it means abc analysis has to consider (date and local) and don't change with slices. I'll be thankfull if could help me in this problem.
Please indicate how that would look like based on your provided sample data. How are you breaking the ties?
