1 Reply Latest reply: Apr 22, 2010 11:34 AM by Michael Solomovich RSS

    Create straight table that only shows the INTERSECTION of selections

    Henry Noh

      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?

       

      Thanks in advance.