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?
Solved! Go to Solution.
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
Hi @akku --
If you add a Summarize tool after your data and configure it to Group by Order Number and Count Order Number. Does that give you what you need? I think I need clarity around the last part of what you are looking to do. Specifically:
"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."
Thanks,
Seth
Hi @smoskowitz
I only want to count item number 3456 if there is any other item with group number 412 under the same order number.
akku
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
Thanks for trying.
But unfortunately it is not what I am looking for.
Take a look at the sample data from the 3rd post.
The individual items are assigned to different groups.
Now I want to sum up quantities of item number "3456", but only on the condition that there is another item number under the same order number that is assigned to group "412".