Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
avenino
Partner - Contributor
Partner - Contributor

Running sum help

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.

running_sum_no_total.png


So I tried adding another aggregation:
SUM(AGGR(RANGESUM(ABOVE(TOTAL $(SelMeasure), 0, YTD)), PDVID, GIROVISITAID))
but I got a strange result.

running_sum_with_aggr.png


 
What am I doing wrong?
 
Thank you in advance!

 

Andrea

Labels (1)
1 Reply
avenino
Partner - Contributor
Partner - Contributor
Author

Hi,

solved working on backend side!

Thanks