Here is the solution using custom states and the hack I was thinking of. There is a fair amount of custom state jiggery pokery going on and I use a custom event that is triggered for the count of rows in the RG to add each transaction to the Grand Total custom state.
Let me know if you have any questions.
