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