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

[Pascal_R]

HI @grazitti_sapna 

I need to have the ABCD classification per Plant now I see it over all Plants.

What I need to see is as an example in Plant 1500 their own ABCD and there the same for each other Plants.

In your workflow its spread over all the Plants any solution for that?

Regards,

Pascal

[grazitti_sapna]

Hi @Pascal_R, will it be possible for you to share an example of desired output?

Thanks.

[Pascal_R]

Hi @grazitti_sapna 

Please see attached file. Hope this helps to understand the needed result.

Regards,

Pascal

[grazitti_sapna]

Hi @Pascal_R , pleaser refer to the workflow attached along with the screenshot.

Let me know in case of any queries.

Thanks.

[Pascal_R]

@grazitti_sapna 

Thank you so much! If there would be an additional parameter within the Plant like within the Brand todo an ABCD I only need to summarize it?

Or is there anything else I need to think about?

Regards,

Pasal 

[Pascal_R]

@grazitti_sapna 

Please see attached file showing you in within Hierarchy level.

I guess  only Summary on Hierarchy level is needed right ?

Regards,

Pascal

[grazitti_sapna]

Hi @Pascal_R , yes it will work with summarize tool.

Please refer to the config below.

Thanks.

[grazitti_sapna · Accepted solution]

@Pascal_R , please find the attached workflow.

Thanks.