Hello,I'm trying to work out how many Orders contain a single unit of a
specific department (classification from Product string), versus Orders
that contain > 1 unit of a specific department.The below doesn't work
for Single Units as I don't want to exclude Orders containing other
Departments Likewise, the below doesn't work for Multiple Units - this
doesn't necessarily mean there's more than 1 Unit of the desired
Department, just that there's more than 1 Unit in total in the orderAny
help would...