The RunningValue function might be what you need here, check out this post:

http://mangalpardeshi.blogspot.com/2009/03/runningvalue-function-reporting.html

You'll likely need to play with the group value you're passing to the function, it talks about that in the second section.

Hope that helps!

Cheers,

EJM