8 Replies Latest reply: Dec 15, 2014 1:02 PM by Rob Wunderlich RSS

    Drill Down Level Inclusive Question

      Hello,

       

      I have a general inquiry regarding Drill Down Groups.  My Current hierarchy is for a geography, where we drill from Area --> Region --> to Territory.

       

      So here is what i would like to achieve:

           When I drill into a particular Area, I see all of the Regions in that Area

           Then when I drill into a given Region, I would like to see all of the Territories in that Area.

       

      Is this possible?? Or are there any work around?

       

       

       

       

       

      This is what I have so far, which is close, but does not achieve the desired effect:

       

      =Sum({$< ProductId = {1}, IsMonth = {1}, RegionName = >} Qty)

       

       

      Thank You!