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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
78 | |
71 | |
48 | |
47 |
User | Count |
---|---|
157 | |
88 | |
81 | |
69 | |
67 |