Intersection

[#1]

I have 5 sales groups with separate lists of clients: I would like to derive the clients which overlap, not the additive you get when you click on multiple sales groups. Ideally, I'd like to have a straight table that would list the intersecting clients for any combination of sales groups. How is this done?

Thanks in advance,

Henry

[#2]

Hi Henry,

Concatenate the 5 groups & customer into one single table.

Pls find the attached application for your reference.

Regards

Rajesh