1 Reply Latest reply: Nov 25, 2014 3:26 PM by Jonathan Poole RSS

    Drill Down Multiple Selection

      Hello:

       

      I have a drill down group the has the following heirarchy:

       

      Nation

      Region

      State

       

      Currently, if i drill into multiple regions, then I see onlyh the multiple regions.  I want to make such if I drill into multiple Regions, I see All of the States within those 2 regions.

       

      Thank You For Your Help

        • Re: Drill Down Multiple Selection
          Jonathan Poole

          Drill groups won't work that way, and a cycle will require 2 clicks.

           

          To do this 'on click' you could include 2 dimensions (Region and Country) and conditionally show one or the other depending if 1 or more Regions have been selected

           

          No Regions Selected

           

           

          Capture1.PNG.png

           

          One or more regions selected

           

          Capture2.PNG.png

           

          The settings are on the dimension tab on each dimension itself, here is the condition for 'Region'

           

          Untitled.png

           

          Region 'enable conditional' expression:   GetSelectedCount(REGION)=0

          Country 'enable conditional'  expression:   GetSelectedCount(REGION)>0