Forum Discussion

Mack1int's avatar
Mack1int
Frequent Visitor
8 years ago
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...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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,

divyakolavil's avatar
divyakolavil
Regular Visitor
3 years ago

Hi,

I have a similar requirement, based on Div/Cat and Gender and YTD Sales Data i need to classify the Article Codes as ABC. 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 is the sample data. 

Thanks in advance

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Please study the file which i shared the link of in my post dated 23-11-2017.  Apply those formulas on your dataset as well.

  • divyakolavil's avatar
    divyakolavil
    Regular Visitor
    3 years ago

    The file is not accessible , it says the item might not exist/no longer available. Could you please reshare it?

     

    Thanks

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      The file has been deleted somehow and i do not have the link now.  Sorry for that.  Share an MS Excel file with your formula/Pivot Tables based workings there.  I will try to translate those formulas in the DAX language.  Give adequate notes/descriptions in the Excel file so that your intention can be well understood.

      • divyakolavil's avatar
        divyakolavil
        Regular Visitor
        3 years ago

        https://we.tl/t-lzSbx44bEv

         

        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