I have an SSRS report which is returning rows per below.

The first row between 15/12/23 and 14/12/24 would be RowNumber 1. The last row between 15/12/24 and 14/12/25 would be RowNumber 2.

This table could have up to 10 rows - but would never exceed it.

Underneath the table the customer wants me to repeat the final value from the Remaining Balance field - in this case the Remaining Balance for Row 2 - which would be £500. However that field where the ?? are would basically need to return the MAX Row Number which could be between 1 or 10. So if there were 5 rows - it would need to return the Remaining Balance from Row 5.

Thanks