12 Replies Latest reply: May 26, 2015 4:25 PM by Ramon Covarrubias RSS

    drilldown - cumulative percentage calculation

    it man

      Hi All,

      I have two drilldown groups, Group1 and Group2 and one expression.

      I would like to display a line chart.

      In the chart, when I drilldown from Dimension1 to Dimension2,

       

      1. The percentages at row level should add upto the percentage at column total. At every dimension level
      2. the percentages achieved at dimension2 level should add upto the total percentage achieved  at dimension1 level.
      3. the percentages achieved at dimension3 level should add upto the total percentage achieved  at dimension2 level.

       

      For eg., if the percentage achieved at Dimension1 level for a field is 40%, then, all the row values at dimension 2 level

      Should add upto 40% only