I have a Variable which holds a Balance figure
I have a grid which has value columns
I want to show a cumulative reducing balance e.g.

MyBalance = 300

MyTable is as follows:
Rec 1 10
Rec 2 3
Rec 3 4

I want to display:

Rec no. Val Cum Balance
------ ---- -----------
Rec 1 10 290
Rec 2 3 287
Rec 3 4 283


I know I can do this with a View but the Source Table can be huge (Hundreads of thousands of records) and I would prefer, if possible, to show the original table with the cumulative coulmn

Regards,

Gerard