Expression for cumulative figures

[Upali_Wijearatne]

I have below Pivot table in my qv file But I am unable obtain balance figure correctly. pls help me with the expression 

[Vegar]

Do you need the if statement for handling the opening balance? If sorted correctly the balance will be the first row and therefore the same as the opening balance anyway. 

Try also using replacing rowno() with  rowno(TOTAL) in your expression.

[Upali_Wijearatne]

Thanks  But it is not working properly.

1010	Bank Account - A/C 000405937 BOC Thimbirigasyaya	11-Dec-24	Re  Investment of DESC FD	Direct debit	0.00	750,000.00	16,378,669.80
1010	Bank Account - A/C 000405937 BOC Thimbirigasyaya	16-Dec-24	Randika Dissanayake Monthly Contribution	1336	1,000.00	0.00	16,379,669.80
1010	Bank Account - A/C 000405937 BOC Thimbirigasyaya	31-Dec-24	Closing Balance	-	0.00	0.00	16,962,029.60
1011	Bank Account - A/C 1991497      BOC Milagiriya	01-Jan-24	Opening Balance	-	0.00	0.00	58,545.61
1011	Bank Account - A/C 1991497      BOC Milagiriya	05-Jan-24	Namal Silva	1034	1,000.00	0.00	17,021,575.21
1011	Bank Account - A/C 1991497      BOC Milagiriya	19-Jan-24	Mat of T Bills	1036	2,794.70	0.00	17,024,369.91
1011	Bank Account - A/C 1991497      BOC Milagiriya	26-Jan-24	Manjula	1035	250.00	0.00	17,024,619.91
1011	Bank Account - A/C 1991497      BOC Milagiriya	05-Feb-24	Namal Silva- monthly  cont	1043	1,000.00	0.00	17,025,619.91
1011	Bank Account - A/C 1991497      BOC Milagiriya	07-Feb-24	Balance confirmation chgs	-	0.00	1,000.00	17,026,619.91