Cumulative sum in Pivot table

[LoretaS]

Hi,

I have a pivot table with acq.date and collections for each month after acq. date (M_Vintage)

I would like to calculate cumulative sum for each line means horizontally.

2024-09 should be 23,3K, 23,3K+15.7K, 23.3K+15.7K+62.7K and etc.

If I use formula rangesum(above(sum(colltotal),0,RowNo())) I get column sums, not row.

Is it possible to do cumulative row?

[brunobertels · Accepted solution]

Hi 

Your expression will not work with above and rownow 

The expression should be changed to respect that:

• Above becomes Before
• RowNo becomes ColumnNo

Rangesum(Before(Sum(colltotal),0,ColumnNo()))

Regards 

[LoretaS]

Thanks it works!

[LoretaS]

I have another question related to this table.

Is it possible to create line chart with two dimensions? X axis would be M_vintage, and each line Capex Date. 

On Y axis cumulative performance. I manage to do only on montly inflow, but not cumulative.

[brunobertels]

Hi 

Line or bar chart works as a straight table so then use above and rowno instead of before and column. 

Regards