Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need some help with a measure: I'm trying to implement a running sum, so that every month of year shows the sum of itself and the previous ones.
I tried with:
RANGESUM(ABOVE(TOTAL $(SelMeasure), 0, YTD))
where $(SelMeasure) contains the meas I want to sum and YTD the number of month to sum: it works, but I cannot have the right total.
So I tried adding another aggregation:
SUM(AGGR(RANGESUM(ABOVE(TOTAL $(SelMeasure), 0, YTD)), PDVID, GIROVISITAID))
but I got a strange result.
What am I doing wrong?
Thank you in advance!
Andrea
Hi,
solved working on backend side!
Thanks