Addition

[Nikhil2725]

Hi Team,

I have a below table.

PH6	PH6_desc	Sales T/O
231546	BV 546	1163729
255373	VAG Produkte	1092099
221051	El. fusion fitti. PB	880487
201950	Solv.cement fitt.me.	874874
230152	Solv. Cement Fit. mm	689215
202956	Ballvalves for water	550592
230153	Adapter Fittings mm	531082
251313	ELGEF Plus saddles	464251
221043	Pipe PB in bars	451753
2J1J54	Regulierarmaturen	432843

Further I want to add new column as below. Kindly help me in doing this.

PH6	PH6_desc	Sales T/O	New Column	Description
231546	BV 546	1163729	1163729	For the first row the value should be same as Sales T/O(1163729)
255373	VAG Produkte	1092099	2255828	Addition of 1st row and 2nd row of Sales T/O(1163729+1092099)
221051	El. fusion fitti. PB	880487	3136315	880487+2255828
201950	Solv.cement fitt.me.	874874	4011189	874874+3136315
230152	Solv. Cement Fit. mm	689215	4700404	689215+4011189
202956	Ballvalves for water	550592	5250996	550592+4700404
230153	Adapter Fittings mm	531082	5782078	531082+5250996
251313	ELGEF Plus saddles	464251	6246329	464251+5782078
221043	Pipe PB in bars	451753	6698082	451753+6246329
2J1J54	Regulierarmaturen	432843	7130925	432843+6698082

[Arthur_Fong]

There should be a column to indicate the sorting for each row to start the cumulative process.

Is there any date column in the table you provided?

[tresesco]

Try like:

RangeSum([Sales T/O], Peek([New Sales T/O])) as [New Sales T/O]

[avinashelite]

You need to achieve this in the front end or back end ? if its front end then so with the full accumulation option in the chart option .

[Nikhil2725]

Hi,

I need to achieve in front end

[Nikhil2725]

Yes. I have a column called billing year.. In billing year there is a value like 2010,2011 and 2012. And i have used Billing year as Filter

[Nikhil2725]

what is Peek([New Sales T/O])) here?

[avinashelite]

Peek is a function to the previously loaded rows in the script level table....

Peek() finds the value of a field in a table for a row that has already been loaded or that exists in internal memory. The row number can be specified, as can the table.

Syntax:  

Peek(field_name[, row_no[, table_name ] ] )

[Nikhil2725]

peek function doesnt help me

[Nikhil2725]

Any Ideas for the above query???