3 Replies Latest reply on May 27, 2016 6:31 AM by Sebastian Hopfensperger

    How do I match different products with the same order number?

    Sebastian Hopfensperger

      This problem is confusing me, and I am not sure if its even possible to do:

       

      I have 1 dimension called Order Number, and a second dimension called Product.

       

       

      Order NumberProduct
      1234A
      1235B
      1236C
      1237D
      1238E
      1239F
      1240G
      1234H
      1235I
      1236J
      1237K
      1238L
      1239M
      1240N

       

       

       

      Each order that is created is an individual line of data (1 line = 1 order).

       

      In this case, some of the order numbers are the same, but with different products next to them i.e. one order number has two (or more) products.

       

      I can view each order by order number, and it shows me the products that are within that order (tableau groups the order numbers automatically in a table).

       

      However, I would like to choose one of the products (A), and let it show me the other product(s) that were also in that order (H). I currently cannot do this, as each line is separate.

       

      I need a formula (or something) that will match the two order numbers together, which then also matches all products together, so i would be able to select A and it will show me that H was also in that order or vice versa:

       

        

      Order NumberProductProduct 2
      1234AH
      1235BI
      1236CJ
      1237DK
      1238EL
      1239FM
      1240GN
      1234HA
      1235IB
      1236JC
      1237KD
      1238LE
      1239MF
      1240NG

       

       

       

      Is this possible and can anyone help?

       

      Thanks a lot.