looking for an expression for cumulative summation in the column

[#1]

Dear Friends

I need an expression for generating the following table

SlNo	PEI	PEI Cumulative
1	100	100
2	200	300
3	500	800
4	-300	500
5	400	900
6	600	1500
7	200	1700
8	100	1800
9	300	2100
10	500	2600
11	-600	2000
12	300	2300

I have the data for columns SlNo and PEI, I want to generate the PEI which holds the cumulative summations.

--

Satyajeet

[edg_baltazar]

If you are using a Straight table , you can use the same expression of PEI but in te expression tab of the object properties check the 'Full Accumulation' option, regards!

[#3]

Hi Edgar, Thank You for solving this problem.

Its working for straight table however the accumulation option is not availaible in case of pivot table.

I am interested to know if it can be done in Pivot table too.

[CELAMBARASAN]

Use Above function

like

RangeSum([PEI], Above(PEI Cumulative))

Celambarasan