cancel
Showing results for 
Search instead for 
Did you mean: 

Create report against a subset of orders

Create report against a subset of orders

I'm trying to create a report that ultimately shows which products are most frequently purchased with which other products. I'm starting with a top 10 set of products for the analysis.

 

I want to create a report where we first select all orders that contain Product A, then list the quantities of other SKUs included in those orders. I can do the second part (list the quantities of other SKUs) but I'm not sure how to start with only those orders that contain Product A.