How to hide the first row in straight table

[yoganantha321]

Hi all,

I have a data like as shown below,

ID	Value
1	5
2	10
3	15
4	20

 
But i need to show in straight table as Sum Value (adding with previous value

I am getting the output as 

ID	Value	Sum Value
1	5
2	10	15
3	15	30
4	20	50

My expected output should be like below 

ID	Value	Sum Value
2	10	15
3	15	30
4	20	50

[pradosh_thakur]

where len(trim([Sum Value])) >0 

where [Sum Value] >0 

[yoganantha321]

Hi Thakur,

Sum Value is an expression

[pradosh_thakur]

Hi Yoganantha

I know [Sum Value] is an expression but you must have given an alias to it. Use where clause on top of it.

Thanks
Pradosh

[pradosh_thakur]

load *
where len(trim([Sum Value])) >0 ;
load * , ...... as [Sum Value]
from table_name'

[yoganantha321]

Thanks

[pradosh_thakur]

Welcome. If this is resolved , please close the thread.

[qv_testing]

try this..

RangeSum(Above(Sum([Value]), 0, RowNo(TOTAL)))

or

RangeSum(Above(Sum([Value]), 0, RowNo()))