Accumulation of a fraction measure in a line graph

[cmc]

I have a line graph with a measure that is a fraction e.g. sum(A) / sum(B).

I would like to accumulate the values of A & B separately. I don't want the total measure values to simply be summed up for each step of the line graph.

Currently, my expression looks like this:

=
RangeSum(Above(
Sum(A)
,0,RowNo()))

/

RangeSum(Above(
Sum(B)
,0,RowNo()))

This works when there is no dimension breakdown in the line graph (e.g. there is only 1 line), but when I add a line dimension, the calculations are incorrect for the accumulated measure.

[sbaro_bd]

Hi @cmc ,

What happen if you declare the dimension inside an aggregate function like this : 

AGGR(your_cumulative_expression, purch_quarter)

Regards.

[cmc]

Hi @sbaro_bd , when I try this method, the result looks like this:

Same if I wrap the numerator and denominator in the aggr() separately.