Forum Discussion

KF94607's avatar
KF94607
Copper Contributor
Jun 18, 2021
Solved

Count orders which contain a certain product

I have a table with data about orders where the products that are ordered each have a separate row, one row per product. Each order starts with an order number and then the product description. I'm looking to count the number of orders which contain each product. I don't want to know the quantity of each product ordered, just the total number of orders which contain each product. (Apple = 2 orders, etc.). The order numbers repeat for each individual product that is ordered, so I'm having a difficult time finding a way to automate the count of individual orders that contain each product. Counting the number of orders or the total number of each product ordered is simple.

 

Order numberProduct
A100Apple
A100Apple
A100Banana
A101Peach
A101Apple
A101Apple
A102Peach
A102Banana
A102Banana

4 Replies

Resources