Hi all, I’m trying to fetch the previous row calculation (this is a separate calculated field which totals all the column values) dynamically in the current row so that balance can be brought forward for next months. Please see a similar example in below table. Please note that the previous row va…

Hi @Brett , thanks for your response. Yes, the ending balance in my sheet is also a calculated field which sums up all the different components of the expense. However, I was able to solve this by using runningSum() in the ending_balance calculated field instead of just sum(). So, I could bring up …

Getting previous row dynamically-calculated field value in current row

Q&A

Brett August 21, 2025, 4:47pm 2

Hi @Murali_Kembhavi and welcome to the Quick Sight community!

It sounds like your ‘ending balance’ column is the ‘previous row value’ that’s a calculated field, correct?
If so, could you please share the syntax for that calculated field?

Additionally, this may be easier to assist further if you’re able to upload a copy of your analysis with annonymized data to Quick Sight Arena so that I can test out some various scenarios:

Topic		Replies	Views
Calculated Field - Error Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	3	132	February 27, 2025
How to create calculate field to fetch previous value in column? Q&A quick-sight , calculations	1	1136	February 4, 2023
How to make QS to keep rolling over previous calculations Q&A quick-sight , calculations , Business-Intelligence-Engineer	4	83	June 17, 2024
Multiple aggregation calculations are showing errors when using with Lag Function Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	10	196	August 13, 2024
Previous row value of a dimension Q&A quick-sight , calculations , Business-Intelligence-Engineer	3	50	May 22, 2025

Getting previous row dynamically-calculated field value in current row

Related topics