December 22, 2011 at 1:23 pm
I am building a report that needs to show the cumulative daily total as shown below:
Date | Today's Total | Cumulative Total
8/1/11 | 100 | 100
8/2/11 | 150 | 250
8/3/11 | 125 | 375
8/4/11 | -50 | 325
I have seen and tried a few scripts from the net, but so far I seem to be missing the mark. My thoughts are next are to try something with the Row_Number() function, but I have not worked out that logic in my head yet. Any help would be greatly appreciated.
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 22, 2011 at 1:31 pm
Jeff Moden has a very good article on exactly this problem. Solving the Running Total and Ordinal Rank Problems (Rewritten)[/url] Be sure that you follow all of the criteria for running the quirky update. Also make sure that that you read the discussion for that article, because there were some improvements suggested that may not have been incorporated back into the article, yet.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply