ABC Analysis based on multiple columns

All forum topics
Previous Topic
Next Topic

Hi all,

I have to categorize Articles based on YTD Sales Data on the column combination of Div-Cat-Gender-Site code.The articles which contributes to the 70% of sales will be calssified as A, 70% to 90% as B, and 90% above as C. Below sample screenshot FYR..

I have tried in excel as per this, not sure if it is 100%. Also attaching the excel file

https://we.tl/t-lzSbx44bEv