Accumulation

[n1ef5ng1]

Scenario, i have a five years set of data in a table that is display in monthly.

Jan - 2008

Feb - 2008

.

.

.

Dec - 2008

Jan - 2009

.

.

.

Mar - 2013

I need to create an accumulative column of values in year basic. meaning that once it hit the december of  a particular year, it will reset back to 0 for jan - 2009

thanks!

[somenathroy]

use below line with LOAD statement:

if( Left(YearMonth,4) = Left(Previous(YearMonth),4) , <Field_Name> + Peek('Accumulative'), <Field_Name>) as Accumulative

Regards,

Som

[n1ef5ng1]

possible to do it without editing the script?

[er_mohit]

take year and value which based on year as dimension in pivot chart

and in expression

write this

rangesum(above(sum(value),0,RowNo()))

hope it helps

[Anonymous]

Hi

For taking only one year values you need to edit the script only..

use the following in ur script

Load *,

RowNo() as Row,

If(Year like 'Jan*',Value, Value+previous(Value)) as ValueNew

;

LOAD * INLINE [

    Year, Value

    Jan2010, 10

    feb2010, 20

    march2010, 30

    april2010, 40

    Jan2011, 50

    feb2011, 60

    march2011, 70

    april2011, 80

];

Then using straight table or table box u can get the data from ValueNew

Hope it helps u

Regards

Revathy

[n1ef5ng1]

for

   Year, Value 

    Jan2010, 10

    feb2010, 20

    march2010, 30

    april2010, 40

    Jan2011, 50

    feb2011, 60

    march2011, 70

    april2011, 80

];

do i have to list out on this list or according to ALL my date on my table?

which is jan 2010 - march 2013

[Anonymous]

According to ur dates u can take, If the field starts with 'jan*' then it wil take only the value else gets accumulated with previous value.

Regards

Revathy

[n1ef5ng1]

LOAD *,

RowNo() as Row,

if(Year like 'Jan*', Value, Value + Previous(Value)) as ValueNew

;

LOAD * Inline

[

Year,Value

Jan-2011,10

Feb-2011,20

Mar-2011,30

Apr-2011,40

May-2011,50

Jun-2011,60

Jul-2011,70

Aug-2011,80

Sep-2011,90

Oct-2011,100

Nov-2011,110

Dec-2011,120

];

this is just 2011, i have to add in 2012,2013?

next, do i have to add anything on the dimension or expression side?

[Anonymous]

Yup, U can add all the data. If u have any problem please uplad the sample qvw.

Regards

Revathy.

[n1ef5ng1]

mine is a personal edition...

Upon adding the code on the script,

what is next? how am i going to retrieve the values of accumulation on Expressions