This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Summary column with rolling sum

Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’ve been looking at a similar topic and wonder if you would consider to add a summary column. I imagine it to be similar to the summary row at the bottom, but make it possible to calculate a rolling sum.

I have columns for date, debit, and credit, so the function would have to look up the previous date. Then it would add the previous sum, the current debit, and subtract the current credit.

This would preserve the visual independence of records and still work if they are reverse or out of order. I realise that this can be achieved with existing functionality but I am a new user and feel like it would be a common enough use case.

Sorry for the cryptic explanation, I’m happy to elaborate. I’m sure that people will come up with similar calculations that can be attached to a record in a column on the right edge.