5 Replies Latest reply on Sep 13, 2012 12:10 PM by Jonathan Drummey

    How to find an order that contains X

    Sean Otto

      Goal:  I want to find all order that have a Xerox item in them.

       

      Similar to a Market Basket analysis - yes I did look at that example, but it didn't get me far and kept giving inaccurate results when attempting to filter - but all I am really doing is creating a filter that says, "if an order has a xerox item in it, then show me all the items".  I've been using the Superstore Sales data as a test case with the following.  Show me all orders that have a Sub-Category of "Paper".  If you filter on "Paper" then it only shows the items with Sub-Category "Paper", but my real interest is in the OrderID (which can have multiple products) and the Orders which had a product sold under the category "Paper".

       

      Any thoughts?

       

      Thanks