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

    Drill Down Level Inclusive Question



      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!