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]

Try this:

Dimension: [Sales T/O]

Expression: PH6

                         PH6_Desc

                        RangeSum(above([Sales T/O],0,RowNo()))

[Kushal_Chawda]

@Arthur_Fong  above expression won't work if you perform selection on PH6 and PH6_desc. You need to use below expression to exclude selections of table dimensions

 RangeSum(above(sum({<PH6,PH6_desc>}[Sales T/O]),0,RowNo())) *avg(1)

[Arthur_Fong]

Thanks for pointing out this.

[Nikhil2725]

Hi, 

Thanks for the reply..

Im taking PH6 and PH6_desc from the DB table. So when i use PH6 and PH6_desc as measure in the front end its showing Null value.. How can i do this ??

[Nikhil2725]

Hi Team,

Any Suggestion on the above query??

[Kushal_Chawda]

You should use it as dimension. They are not the measure

[mahaveerbiraj]

Hi nikil ,

try below expression i hope it will help you .

rangesum(above(sum([Sale T/O],0.rowno())))

[mahaveerbiraj]

try this nikil ,

rangesum(above(sum([Sale T/O],0.rowno())))

[Nikhil2725]

Hi,

If, I use PH6 and PH6_desc as dimension im not getting the desired output..

Please find the attached file.

[Nikhil2725]

Hi Team,

Any Update?