Line Graph: Accumulating a Fraction Measure

[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.

[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.

[vincent_ardiet_]

Indeed, this doesn't seem to work as expected whereas in a table or a pivot this is working well...

[cmc]

Agreed, it is very unfortunate 🙁