abc classifciation calculation on sales history

[Pascal_R]

Hi all,

I have Material number and the sales data last past 6 months.

How can I calculate the classification if I have to consider below ABC rules:

A= 50% B=30 C=15 D=5

Please see attached example of dateset.

Thank you for any help on this.

Pascal

[jdunkerley79]

Can you give more detail on what you want the result to be?

Do you want to allocate the QTY of each material into four classifications (A-D)?

[Pascal_R]

@jdunkerley79 

Please see attached excel file where you can see what I need to try in Alteryx.

Hope this helps to understand it more.

Please let me know.

Regards,

Pascal

[atcodedog05]

Hi @Pascal_R ,

Here a workflow for the task.

Input

Output. Getting expected output.

Hope this helps. Please check and let me know.

Please mark this post as solution if it solves your requirement.

[Pascal_R]

Hi @atcodedog05 

Thank you very much for your fast replay.

If I try to open the workflow I got attached error.

Are you able to send it in the yxmd format?

Regards,

Pascal

[grazitti_sapna · Accepted solution]

Hi @Pascal_R , give this a try if it works for you.

If this is what you are looking for then please mark this post as solution/

Thanks.

[atcodedog05 · Accepted solution]

Hi @Pascal_R 

Please find the workflow.

[jdunkerley79 · Accepted solution]

I'd suggest: 

- Sort into ascending QTY

- Use a running total tool to create a running total of QTY

- Use a summarise tool to make the grand total

- Use an append field to add the grand total to all rows

- Calculate the PctTotal as (RunningTotal - QTY) / GrandTotal: this give % used at start

- Allocate to A,B,C,D. I used a formula tool:

IF [PctTotal]<0.05 THEN "D"
ELSEIF [PctTotal]<0.2 THEN "C"
ELSEIF [PctTotal]<0.5 THEN "B"
ELSE "A"
ENDIF

Sample attached

[Pascal_R]

Hi @grazitti_sapna 

Would that also be possible if I have date from different countries and need to do  the ABCD analysis then split by country?

Please see attached example data as a starting poin.

Regards,

Pascal

[grazitti_sapna · Accepted solution]

@Pascal_R , give this a try.

In running total tool group by plant so it will give you result as required.

Thanks.