7 Replies Latest reply: Jan 31, 2014 2:31 PM by Ryuma Nakano RSS

    Dynamic Cyclic Group drilldown based on selection

      I was wondering if we have an option or workaround to dynamically drilldown in cyclic group based on selection.

       

      Ex: I have a chart which gives Sales numbers for market hierarchy(region(4)>Area(10)>Market(52)>Submarket(185)). Now I have these Market levels in Cyclic group. Add it to a dimension in my chart.

       

      When user makes a selection on Region(1/4) and Area(1/10)... the chart still shows numbers for Region.... I prefer to see the cyclic group to dynamically drill down to Market and still give option to user to toggle between Market levels.

       

      Any suggestions and ideas?