Accumulative

[#1]

Hi  This is my Report I need to O/P Like This Pls anyone Send the Expression For this Report.

I need it urgently.

Thanks in advance

[MK_QSL]

Script

===================================

Temp:
Load Date, ID, Value From TableName;

Final:

Load *, RowNo() as NO Resident Temp Order By Date, ID;

Drop Table Temp;

=========================================

Create Straight Table

Dimension

NO

Date

ID

Expression

Value

SUM(Value)

O/P

RangeSum(Above(SUM(Value),0,RowNo()))

[its_anandrjs]

Hi,

In Expression try

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

Regards

Anand

[its_anandrjs]

Hi,

In load script you can use it like

Tab1:

LOAD * INLINE [

    Date, ID, Value, O/P

    10-10-2009, A, 10, 10

    10-10-2009, A, 15, 25

    10-10-2009, A, 5, 30

    10-10-2009, A, 40, 70

    10-10-2009, A, 20, 90

    10-10-2009, B, 10, 10

    10-10-2009, B, 20, 30

    10-10-2009, B, 15, 45

    10-10-2009, B, 45, 90

    10-10-2009, B, 25, 115

    10-10-2009, B, 10, 125

    10-10-2009, C, 5, 5

    10-10-2009, C, 15, 20

    10-10-2009, C, 20, 40

    10-10-2009, C, 10, 50

    10-10-2009, C, 25, 75

    10-10-2009 C, 12, 87

    10-10-2009, C, 10, 97

    10-10-2009, C, 20, 117

    10-10-2009, C, 50, 167

];

New:

LOAD

Date,ID,Value,

if(Previous(ID) = ID, Value + Peek(OP),Value)  as OP

Resident Tab1;

DROP Table Tab1;

And you get this records

Regards

Anand

[#5]

Actually i have tried these things and it worked,,bt i need it in some other way...

thanks for the before Scripts and Expressions