Thank you for the quick reply, but that isn't exactly what I'm looking for. Say I have the following rows in the table:
Since I only want to show the Orders that have Item 1 on them with additional items I would like to see:
0019_0000011111_2018,0019,2 where 2 is the total number of lines on the order
I Think I Got This, using your Sample Data. So the Question was if order id Contains Item1 and if has additional Items along with Item 1, then TRUE.
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread
Filtering by Count.twbx 12.7 KB
I need to revise this a little. I want to get orders that contain only items Item 1 and/or Item 2, but no other items. So if order 1 contains Item 1 it qualifies, if order 1 contains Item 1 and item 2 it qualifies, but if order 1 contains item 1 and item 3 it does not.
Would that be a contains?