how to add values to total

[Anonymous]

Hi,

I need help,

How can I add values to the total field as shown below.

Product	Value	Total
A	100	100
B	250	350
C	50	400
D	50	450

In my source I have only Product and value fields . How can I calculate Total Field.

[ychaitanya]

you can use like this :

above(sum(value),0,rowno()-1)

Thanks

[ychaitanya]

Use this

aggr( rangesum(above( sum(Price), 0, rowno() )), Price)

[Digvijay_Singh]

May be this for Total measure -

Rangesum(Above(Sum(Value),0,Rowno()))

[MarcoWedel]

Hi,

maybe helpful:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Straight_Table.htm#kanch...

regards

Marco

[shiveshsingh]

like this

RangeSum(above(sum(Price),0,RowNo()))