Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Count(DISTINCT {<[Sales order] = P({<[Order Items] = {'A'}>})*P({<[Order Items] = {'B'}>})>}[Sales order])
May be this
Count(DISTINCT {<[Sales order] = P({<[Order Items] = {'A'}>})*P({<[Order Items] = {'B'}>})>}[Sales order])
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
Thank you Sunny, that worked great!
Hi Sunny,
Can you guide me on set Expressions?
Means from where I can learn it better.