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?

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 Number Product 1234 A 1235 B 1236 C 1237 D 1238 E 1239 F 1240 G 1234 H 1235 I 1236 J 1237 K 1238 L 1239 M 1240 N

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 Number Product Product 2 1234 A H 1235 B I 1236 C J 1237 D K 1238 E L 1239 F M 1240 G N 1234 H A 1235 I B 1236 J C 1237 K D 1238 L E 1239 M F 1240 N G

Is this possible and can anyone help?

Thanks a lot.

• ###### 1. Re: How do I Match the same

Hi Sebastian

Reading your question. the first thing which springs to mind is a cross-join.

That will create a larger data set whereby each order has all products and vice versa.

If i can find any time, I'll try and mock something up for you... but don't wait on me!

Best of luck

Cheers

Mark