Find combination of 2 values in a dimension

[#1]

Hi all, My first post here so please go easy on me;)

I have a table containing Sales orders & order items and i'm looking for an easy way to

filter out all sales order containing 2 specific order items.

In the example below i have 4 orders, but only sales order 1 & 2 has both Order item A and Order item B

Sales order	Order items
1	A
1	B
1	C
2	A
2	D
2	B
3	F
3	G
4	A

Is there a way to filter out all the orders containing both order item, excluding orders that only contain one in a table or chart.

Ideally i would like to use input fields to set the variables for which order items to filter on.

Any suggestions would be very appreciated

Thank you

Best regards

Thord

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<[Sales order] = P({<[Order Items] = {'A'}>})*P({<[Order Items] = {'B'}>})>}[Sales order])

[vvira1316]

Depending on data model/tables it may be possible to do it in script itself.

Select only those orders where order items = A and order items = B.

Will you be able to post any sample of your data and/script?

BR,

Vijay

[#4]

Thank you Sunny, that worked great!

[Shubham_Deshmukh]

Hi Sunny,

Can you guide me on set Expressions?

Means from where I can learn it better.