Accumulate Sum for prev Year and start over at beginning of current year

[lorenwood]

Hello, I wanted to know if this is possible in Qlikview.  See below table: I am wondering if it is possible to get a rolling accumulation for the year 2013 then have the sum begin new at the beginning of 2014 the chart is broken out into Month/Year.  The desired value is in RED and BLUE

Any help would be greatly appreciated!!!

Thanks

Month / Year	Value	Accumulation
Jan-13	5	5
Feb-13	10	15
Mar-13	4	19
Apr-13	5	24
May-13	12	36
Jun-13	5	41
Jul-13	8	49
Aug-13	10	59
Sep-13	2	61
Oct-13	5	66
Nov-13	10	76
Dec-13	20	96
Jan-14	2	2
Feb-14	5	7
Mar-14	8	15
Apr-14	17	32
May-14	20	52
Jun-14	10	62
Jul-14	5	67
Sep-14	8	75
Oct-14	6	81
Nov-14	10	91
Dec-14	15	106

[javier_florian]

Hi Loren,

Try with:

-Sum({<Month={"<=$(=Num(Max(Month)))"}, Year={$(vMaxYear)}>} Value)

-JFlorian

[mayck001]

Try use

SUM (TOTAL( 'FIELD') )

tks

[SergeyMak]

Try this

RangeSum(above(Sum(Value),0,Calendar.MonthNo))

You should have a field with a number of month. In my case it's Calendar.MonthNo