RG height to adjust to data

Hi everyone

I would appreciate help with an issue I am facing.

I have a report as a Repeating Group as shown in the picture:

I have a text box at the bottom that shows the total value . Is it possible to adjust the height of the RG to the extent of the data shown so that the total comes closer to the data?

Thanks in advance

Deepak