I am trying to find out dynamic intersection between three or more selections in a field

[#1]

I have these two fields Retailer and Products that these retailers sell. When i select, suppose A, B, C i want to see the common items these retailers are selling. suppose if I select A,B,C i want to see Rice on the other field 'Products'. How can i create an expression using intersection? thanks.

[ramoncova06]

can you provide an example for the data set and expected result

[swuehl]

Have you looked into an AND-mode list box?

[rwunderlich]

It depends exactly on how you want to display the products. But given a Dim of Product, a set expression of:

{<Product={"=count(DISTINCT Retailer)=count(DISTINCT TOTAL Retailer)"}>}

would I think make the set. See attached for examples of using that in a listbox and straight table.

-Rob

http://masterssummit.com

http://robwunderlich.com

[petter]

Interesting solution ... but I had a hard time really understanding it until I visualized it for myself in this somewhat less efficient - but exactly similar logic:

The title of the Straight Table contains the expression of the second column.

Where I could see visually the list of retailers for each product and the count and comparing it to the total selected...

[#6]

Hi Ramon,
I have attached dataset and Expected output in the post. Thanks

[#7]

Hi Petter,
I just updated the Post with dataset and Expected result. Let me explain you, If i select three or more different retailers, i should be able to see the common items these retailers sell. Thanks

[petter]

Actually you have a perfectly good solution from Rob - mine was just a comment and I sent it to Rob really ... I didn't mean to create any confusion.