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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Break on a running sum 1

Status
Not open for further replies.

mlbateswi

Technical User
Joined
Jan 23, 2002
Messages
1
Location
US
I have a crosstab report that I need to apply a running sum to. I want the running sum to start over on each row of the table(each quarter). I know I have heard of this, but can't remember/find a solution.
Thanks!
 
Hello mlbateswi,

I think that you want a reset context on your running sum.
Suppose you do a running sum om quantities over several months. If you want the running sum to start again with each new month , the syntax will be:

RunningSum(<quantity>;<month>)

this resets the counter.

The column that does the running sum should be directly to the left or right of the quantity column.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top