
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cumulative sum in Pivot table
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?
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Your expression will not work with above and rownow
The expression should be changed to respect that:
Above
becomesBefore
RowNo
becomesColumnNo
Rangesum(Before(Sum(colltotal),0,ColumnNo()))
Regards


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Your expression will not work with above and rownow
The expression should be changed to respect that:
Above
becomesBefore
RowNo
becomesColumnNo
Rangesum(Before(Sum(colltotal),0,ColumnNo()))
Regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks it works!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Line or bar chart works as a straight table so then use above and rowno instead of before and column.
Regards
