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,

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

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        Hi,

        My method is taking a lot of time to process and still not returning the correct result.  Please start a new thread.  I am sure others will help you.