How to calculate running total of a column?

[that_anonymous_guy]

I have a table like this. I want to create another column in the front table which will give me running total of Value. Eg ValueSum column like shown in the example

Project Code	Activity ID	Value	*ValueSum*
1	001	3	3
1	002	2	5
1	003	4	9
1	004	1	10
1	005	7	17
2	006	6	23
2	007	9	32
2	008	14	46
2	009	5	51

[MindaugasBacius]

In the front end, I would suggest using Modifier > Accumulation.

This can be found under Measures properties.

[that_anonymous_guy]

I have to do this in front end table

[Parthiban]

Hi,

Try this in your measure,

=aggr(RangeSum(Above(Sum( Value),0, RowNo())),[Activity ID])

[Ahidhar]

try this

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

[Aunitha]

Hi , Try this
aggr(RangeSum(ABove(Sum(Value),0,RowNo())),Value)