Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()))
Hi,
In Expression try
rangesum(above(sum(Value, 0 , RowNo())))
Regards
Anand
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
Actually i have tried these things and it worked,,bt i need it in some other way...
thanks for the before Scripts and Expressions