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.
Indeed, this doesn't seem to work as expected whereas in a table or a pivot this is working well...
Agreed, it is very unfortunate 🙁