1 Reply Latest reply on May 24, 2016 8:21 AM by Amanda Thompson

    Displaying duplicate items in market basket analysis

    Amanda Thompson

      Hi all,

       

      I'm attempting to figure out how to modify my attached workbook to show that Order ID 1111 has a basket of "Soda, Soda" and not just "Soda". Any ideas?

       

      Here is my current view:

       

      Current View.PNG

      Here is my desired view (I highlighted the example in question):

       

      Desired view.PNG

       

      My formula for Items in Order is:

       

      REPLACE( "*" +

      { FIXED [Order ID] : MAX( IF [Item_Subcategory] = "Hot Dog" THEN ", Hot Dog" ELSE "" END ) } +

      { FIXED [Order ID] : MAX( IF [Item_Subcategory] = "Nachos" THEN ", Nachos" ELSE "" END ) } +

      { FIXED [Order ID] : MAX( IF [Item_Subcategory] = "Soda" THEN ", Soda" ELSE "" END ) } +

      { FIXED [Order ID] : MAX( IF [Item_Subcategory] = "Hamburger" THEN ", Hamburger" ELSE "" END ) } +

      { FIXED [Order ID] : MAX( IF [Item_Subcategory] = "Draft Beer" THEN ", Draft Beer" ELSE "" END ) } +

      { FIXED [Order ID] : MAX( IF [Item_Subcategory] = "Fries" THEN ", Fries" ELSE "" END ) } +

      { FIXED [Order ID] : MAX( IF [Item_Subcategory] = "Water" THEN ", Water" ELSE "" END ) } , "*, ", "" )

       

      My data is below, and attached.

       

      Data Set.PNG

       

      Thanks in advance for your help.