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
