cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
divyakolavil
Regular Visitor

ABC Analysis based on multiple columns

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

 

divyakolavil_0-1675170761959.png

 

 

0 REPLIES 0

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors