Accumulative

[n1ef5ng1]

Hi Guys,

Is there any way I can create such a accumulation on my expression?

Desire output

Date	Value	Accumulative Value
Jan 2011	1	1
Feb 2011	2	3
Mar 2011	7	10
Apr 2011	4	14
May 2011	5	19
June 2011	8	27
July 2011	10	37
Aug 211	2	39
Sep 2011	7	46
Oct 2011	2	48
Nov 2011	1	49
Dec 2011	8	57
Jan 2012`	9	9
Feb 2012	1	10
March 2012	9	19

The accumulative value will reset once it reach end of Dec. Is there any way I am able to do that?

I am using this code at the moment rangesum(above(sum(TEU),0,mod(month(Year),12)+1)), and it is not working. thanks

[n1ef5ng1]

The value that you mentioned, is it referring to the value that i name on the table?

[Sokkorn]

Hi,

Did you try my script above?

Rgds,

Sokkorn

[n1ef5ng1]

Hi i am unable to edit the script as it might affect the rest of the sheets. terribly sorry about that

[er_mohit]

in my application i used dimension year and ncount

and expression accumulate

see in my application it works for per year accumulation

[n1ef5ng1]

sorry but what is ncount for?

[MK_QSL]

Use Year(Date) as Year while loading script...

While making table, use Year as dimension and hide it using presentation tab is not needed.

In Expression tab, use Full Accululation as shown in earlier reply by some of our friends.

Hope this will help.

[er_mohit]

ncount and year is my fieldname

i post you our example as per your need