You can get a running value of a data field(s) using the RunningValue data function. The attached report demonstrates a possible solution for the described scenario.
Regards,
Nasko
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.