I've never used suiteql, as I'm trying to create this as a saved search to pass off to someone else, is there a way to get this same effect using a saved customer or transaction search? For added clarity:
Lets say I have customers A,B and Items X,Y
Customer A has bought ONLY item X
Customer B has bought BOTH item X and Y
I want to create a saved search that would only return customers that purchased items X exclusively.
Currently, I have a saved search that can return customers that have purchased ANY of items X, and Y, but I am having troubles making it return customers that have purchased ONLY items X,Y