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