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.
