yes, so ideally I get orders that just have A

2 summary criteria. 1)Case when item equals a then 1 else 0 end. Type is sum . criteria is greater than 0. 2)Case when item equals b then 1 else 0 end type is sum Criteria equals 0 Ressults are grouped by document number @Martin Salas

@Martin Salas Have you tried this- ((Item = Any of A, B) AND IS NOT (Item = None of A,B)) And of course you can group/ summarize the results by SO# etc.

Your results would not be the desired effect, it would return lines that were only a and b because each line is evaluated independently. summary criteria evaluates the entire order at once.

There is also the ‘Item in Any Line’ criteria wherein you can include/exclude sales orders if they have specific items Edit: oops did not see Eric’s response