Line Graphic Sum

[JASalinas]

Hi my Friends, I need your help, I have the next measure

=(Sum({<[YearPeriod] = {"2021"},[ACCNT_CODE]={"10*","36*"}>}[AMOUNT]*-1)
+ (sum({<[YearPeriod] = {">=1844 <=2020"},[ACCNT_CODE]={"10*","36*"}>}[AMOUNT]*-1)))

And shows the following graph

It shows me the monthly balance but I want it to show me in January the result of the sum of December + January, in February the result of the sum of January + February, in March the result of the sum of February + March etc.

Ex. January 8,944,830.98 - 511,809.44 = 8,433,021.54

       February 8,433,021.54 + 3,917,866.98 = 12,350,888.50

       March      12,350,888.50 + 171,594.98 = 12,522,483.50 etc.

Thank your help.

[chrismarlow · Accepted solution]

Hi,

I think you are going to need to do something like;

RangeSum(Above(Sum( ... Your Measure ...),0,2))

You might need to tweak your set analysis depending on how the numbers come together for Dec/Jan at the start.

Cheers,

Chris.

[JASalinas]

Hi my Friend, I tried but don't work, just advanced one month...

[JASalinas · Accepted solution]

Yes My Friend, I have to change the meseure, but This work with you answer... thank you very much...

(RangeSum(Above(Sum({<[YearPeriod] = {">=1844 <=$(=YearPeriod)"}, [ACCNT_CODE]={"10*","36*"}>}[AMOUNT]*-1), 0, RowNo())))