Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi @cmc ,
What happen if you declare the dimension inside an aggregate function like this :
AGGR(your_cumulative_expression, purch_quarter)
Regards.
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.