Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

abc classifciation calculation on sales history

Pascal_R
8 - Asteroid

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

17 REPLIES 17
Pascal_R
8 - Asteroid

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
17 - Castor

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

Thanks.

Sapna Gupta
Pascal_R
8 - Asteroid

Hi @grazitti_sapna 

 

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

 

Regards,

Pascal

grazitti_sapna
17 - Castor

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

grazitti_sapna_0-1600853393868.png

 

Let me know in case of any queries.

 

Thanks.

Sapna Gupta
Pascal_R
8 - Asteroid

@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
8 - Asteroid

@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
17 - Castor

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

Please refer to the config below.

grazitti_sapna_0-1600858099974.png

Thanks.

Sapna Gupta
grazitti_sapna
17 - Castor

@Pascal_R , please find the attached workflow.

grazitti_sapna_0-1600859177488.png

 

Thanks.

 

Sapna Gupta
Labels