drilldown - cumulative percentage calculation

[Anonymous]

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

[ramoncova06]

this one works according to the description in the document

[Anonymous]

Hi Ramon,

It is only working by first drilldown group, not by second drilldown group.

I am pulling my hair out 😕

Please see the attachement.

[ramoncova06]

try with a nested if

=if(GetCurrentField(DrilldownByTime) = 'TripMonthYear',

  if (GetCurrentField(DrilldownByDelay) = 'Rail', Num(sum(LateTrips)/count(LateTrips),'##.##%'),

  Num(sum(LateTrips)/COUNT( total <TripMonthYear> {<DelayType>} LateTrips),'##.##%')

  ), Num(sum(LateTrips)/COUNT( total <TripMonthYear> {<DelayType>} LateTrips),'##.##%')

  )