Create straight table that only shows the INTERSECTION of selections
I have sales groups with some exclusive and some overlapping clients. How do I create a STRAIGHT TABLE that will only show the INTERSECTING clients with additional selections. The end result will be that if I click on sales group A, it will list all of A's clients, then if I click on sales group B, it will DECREASE the number of clients shown, presenting only the overlapping clients of both sales groups.
I'm pretty sure it involves set analysis using the '*' intersecting syntax but how exactly is this done?