10 Replies Latest reply: May 9, 2012 3:18 AM by sumitharsh RSS

Drill Down

sumitharsh

I have created a drilldown group with Region, District and Territory. Now when i click on any Region it drills down to District, Clciking District drills down to Territory. Now if i am clicking on Territory only one Territory is selected and other territories get excluded. I want that even if i click on any Territory then all the Territories in a particular district should appear without excluding the other possible Territories in that particular District (i.e. it should not drilldown further after Territory). How this can be down ?

  • Drill Down
    Martin Pohl

    maybe change the type of the group from drill down to cycle?

    Regards

    • Drill Down
      sumitharsh

      I can not do that. My requirement is such that i have to use Drill Down Group only.

      • Re: Drill Down
        jveldhoen

        What you can do, is build a trigger to prevent the selection of any Territory value. This trigger will undo any made selection on territory immediately.

        Please see my attached example.

         

        You can find the trigger at Document Properties -> Triggers:

            - Document Event Trigger 'OnAnySelect'

            - Field Event Trigger 'OnSelect'

        • Drill Down
          sumitharsh

          Thanks for the reply JV. But can i do this for a particular sheet. Because i have to show the selections of territories inother sheets. Through this trigger i can not select territories in my entire report. But i want this to happen only for one sheet.

          • Drill Down
            sumitharsh

            Hi JV,

             

            I have given the action in sheet properties. It is working fine but the problem is when i am moving to the previous sheet where i had selected some territory the selections are lost. i have to maintain my territory selection when i move back to the first sheet but this action is clearing the selection of territories.

            • Drill Down
              jveldhoen

              Hi,

               

              I am afraid you cannot restrict this to a single sheet. Unfortunately the Sheet triggers are more limited.

            • Re: Drill Down
              Nicole Smith

              You can apply this on an object by object basis by using set analysis:

               

              {<Territory = >} will cause any selections in Territory to not affect the chart.

               

              (I have also attached the above .qvw with this applied to the chart.)

              • Re: Drill Down
                sumitharsh
                Hi Nicole,
                I have this expression but this is not working.

                if(Segments='Advocates',

                (SUM({$<%EPID={1}, Segment={'Advocates'}, TERRITORY=>}(eTRx_Volume_Change))/
                (SUM({$<%EPID={1}, Segment={'Advocates'},TERRITORY=>}(eTRx_Volume))-
                SUM({$<%EPID={1}, Segment={'Advocates'},TERRITORY=>}(eTRx_Volume_Change)))),


                (SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change))/
                (SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume))-
                SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change)))))
                How can i modify so that it works ??
                • Re: Drill Down
                  Nicole Smith

                  Can you post a .qvw with sample data (or scramble the data that you already have)?  I can't tell what is going on without actually seeing it.

                  • Re: Drill Down
                    sumitharsh

                    Finally got my answer.

                     

                     

                    if(GetCurrentField([DrillDownGroupName])= 'TERRITORY',



                    (SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume_Change))/
                    (SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume))-
                    SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume_Change)))),

                    (SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change))/
                    (SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume))-
                    SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change)))))

                     

                     

                    Thanks