Set Analysis - how to show customers that do not own a certain product(s)

[maprinci]

Hi,

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.

CustomerID      Products

1                       A,B

2                       B,C,D

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.

Melissa

[swuehl]

Maybe something like this with Product A selected

=Concat({<CustomerID = e(), Products= >} DISTINCT CustomerID)

You need to clear selections in Products to avoid an incompatible set (or use

=Concat({1<CustomerID = e() >} DISTINCT CustomerID)

which also ignores any other selection)