Chart with monthly gross and cummulative gross ?

[suvechha_b]

Hi All ,

I got the Aug Gross and Sep Gross measures , how should the Aug Gross Cummulative and Sep Gross Cummulative figures work like below image.?

sample model attached.

[suvechha_b]

Please kindly see , if my Measures -'Sep Gross Cumm' and 'Aug Gross Cumm' is correct.

[tomovangel · Accepted solution]

Hi, for cummulative sum, can you try this :

Rangesum(
above(
Sum({< TransMonth = {"$(vMaxMonth)"},TransYear= {"$(vMaxYear)"}>}GROSS_CLAIMS_PAID)

,0,Rowno(total)))