4 Replies Latest reply on Aug 3, 2018 12:16 PM by John Sobczak

    How to divide column into multiple dimmentions

    A Har

      I am unfortunately unable to share my actual workbook but have created a simulated dataset that reflects the problem I am facing.

       

      I'm working with a database of product orders and the add-ons purchased with each product... it looks something like this:

          

      Order #ProductAdd-onAdd-on Type
      1000BaseAW-01Widget
      1000BaseAD-01Dongle
      1001BaseAW-01Widget
      1001BaseAD-01Dongle
      1002BaseAW-02Widget
      1003BaseAD-02Dongle
      1004BaseAW-01Widget
      1004BaseAD-01Dongle
      1005BaseAW-02Widget
      1005BaseAD-02Dongle


      And what I'd like to get is a view where I can see how many orders of each possible combination of add-ons there have been sold:

        

      ProductWidgetDongleCount of Orders

       

       

      BaseA

      W-01D-013
      W-02D-021
      W-02NULL1
      NULLD-021

       

      I've been able to get the desired view by joining the table to itself and filtering once for widgets and once for dongles, but given the number of rows in the actual dataset, the performance is very slow. Is there a better way?