Forum Discussion
Solved
ABC Analysis
Good Evening Everyone! I have been working over the last few weeks on creating an ABC analysis however, I am still struggling with the calculations and formulas necessary to meet the requirement...
Hi,
See if my solution in this file helps. I think some of your answers in the ABC column are wrong. Please check my ABC column,
Please download the excel file from above link. My requirement is Div-Cat-Gender-Site code - based on these 4 columns the YTD Sales cumulative to be calculated , and the articles which are contributing to 70% of the Cumulative sales will be categorized as A, 70-95% as B and rest all as C. I have tried in excel as per this, not sure if it is 100%. Please input your valuable feedbacks/suggestions. Thanks again
Hi,
My method is taking a lot of time to process and still not returning the correct result. Please start a new thread. I am sure others will help you.
Sure Ashish, Thanks alot for taking the effort