Add below Value

[rohit214]

Hi all,

Sorry for asking silly question but i  am not able to get the anwer

Data look Like this i have 2 fields Date  and Value and 3rd column shows the the required ouptput.

Date	Value	Required Output
01-01-2013	100	100
02-01-2013	200	300
03-01-2013	300	600
04-01-2013	400	1000
05-01-2013	500	1500
06-01-2013	600	2100

Thanks

rohit

[rohit214]

any one.....

[nagaiank]

In straight table chart, define Date as dimension and Sum(Value) as expression. Check Full Accu,u;ation in the Accumulation box in the properties window Expressions tab to get cumulative (required) value.

[rohit214]

hi Sir,

thanks for your answer,

I want that in a field in back end or using expression in front end.

thanks

rohit

[#5]

Try the below expression..

=Rangesum(above(sum(Value),0,rowno()))

[jagan]

Hi Rohit,

If you are try this in script then use below script

Test:

LOAD *,

If(RowNo() = 1, Sales, Peek('AccumulatedSales') + Sales) AS AccumulatedSales

INLINE [ 

    Year, Sales

    2008, 1000

    2009, 2000

    2010, 3000

    2011, 2000

    2012, 3000

    2013, 4000

];

Regards,

Jagan.

[jagan]

Hi Rohit,

PFA file for solution.

Regards,

Jagan.