cummulative data

[#1]

Hi ,

Here my data and result is given below

Plant	Plant1	Date	Amount
P1	PP1	1-Jan-10	2000
P1	PP1	2-Jan-10	-100
P1	PP1	1-Feb-10	200
P1	PP1	1-Mar-10	-3000
P2	PP1	1-Jan-10	2000
P2	PP1	2-Jan-10	-100
P2	PP1	1-Feb-10	200
P2	PP1	1-Mar-10	-3000

Result

Plant	Plant1	Date	Cummulative Amount
P1	PP1	1-Jan-10	2000
P1	PP1	2-Jan-10	1900
P1	PP1	1-Feb-10	2100
P1	PP1	1-Mar-10	-900
P2	PP1	1-Jan-10	2000
P2	PP1	2-Jan-10	1900
P2	PP1	1-Feb-10	2100
P2	PP1	1-Mar-10	-900

Please help me.

regards,

Aruensh

[#2]

If you are showing it in a straight table check the complete ackumulation box on the expression (sum(amount).

Make sure your dimensions are sorted.

/Michael

[#3]

thanks u support ..

But i want to built this logic in script and selection basis .

I wrote this script

Transactions:

LOAD

Plant

,

Plant1

,

Date

,

Amount

as Amount

,

(

numsum(Amount, peek([Cummulative Amount]))) as

[Cummulative Amount]

FROM

(

ooxml, embedded labels, table is Sheet1

)

but problem is that i cant group plant and date wise

regards,

Arunesh kumar

[brenner_martina]

Hi Arunesh,

the script looks like this:

Amount,

(Amount + If(Not IsNull(peek(Amount)),peek(Amount),0)) as [Cummulative Amount]