Looking for help for a specific workflow

Hi Guys,

I am brand new with alteryx and I have a problem that I would like to solve.
I have sales data with the following columns:
- Order number
- Item number
- Amount
- Product group number

There is one line for each order and article. If several different items were sold in one order, there is a row for each item.
I now have to calculate the quantity sold for a specific article number. However, the article number may only be counted if another article with a certain product group number was sold with the same order number.
Unfortunately I have absolutely no idea how to create the workflow here.
Could someone help me here?

Workflow

Help

Accepted answers

akku

Thank you guys for the support, even on weekends. I have now come up with the solution myself. I had thought too complicated, but it is very simple.

For those who are interested, I'll attach my workflow with the sample data.

Have a nice one.

akku

akku.yxmd

All comments

smoskowitz

Hi @AKKW --

I think it would be helpful if we had some sample data to look at. Is that something you can provide?

Thanks,

Seth

akku

OK,
Sample data attached.
The quantity of item number 3456 should be summed up if any item from group 412 was sold under the same order number.

akku

sample-data.xlsx

htrivedi123

Hi @akku ,

It seems to me you will need to use summarize tool and groupby different fields to get what you are looking for.

You may potentially have to use formula tool to make a connection between item number and group

hope this helps,

Thanks,
Hardik

Bruce_V

If I understand you correctly, you are trying to sum up quantities based on order numbers? And you would like the quantities based on item number.

If so I have created attached flow that should work for you.

20200613_Summarize.yxmd

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335