I am slowly learning about set analysis and have tried playing with the E() function but have not had any luck with this yet. I have a data set with customers and products they own.
3 A, D, E
4 E, F
I want to somehow filter another table/field to show CustomerIDs that do not own certain products. For example, if the user selects Product A, I would want CustomerIDs 2 and 4 to show with their products, since they do not own Product A.
Any help is appreciated.