Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tablix with Cumulative Summing

Status
Not open for further replies.

cs2009

Programmer
Aug 10, 2009
50
US
Using SSRS 2008 R2.

I have data returned from a query like this:

Month Order Count
Jan 5
Feb 10
Mar 15
Apr 20

I need to sum the order counts over time (a cumulative count) like this:

Jan Feb Mar Apr
5 15 30 50

Is this possible to do with the tablix control? If so, please explain how.
 
The RunningValue() function is what I need.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top