Running Totals Using Reporting Services

Who is online?  0 guests and 0 members
Home  »  Blogs  »  briankmcdonald  »  Running Totals Using Reporting Services
 
4.29
/5
Avg: 4.29/5: (1 votes)

Comments (2)

AndySugs
AndySugs said:

Hi Brian. Thanks for the article on creating running totals. It's very helpful but I wonder if you could extend it to help me create conditional running total.

I want to create sub-totals on fees column where case no. code = "DDT", "SQR", "BTK"

So, above the fees grand-total would be sub-total for fees where case no code is "DDT"; then below this would be sub-total for fees where case no code is "SQR"; and below this would be sub-total for fees where case no code is "DDT".

I've serached Google for solution but can't seem to crack it.

Your help would be greatly appreciated!

 

 

 

 

10/8/2010
 · 
 
by
briankmcdonald

Andy,

You're welcome! As for assisting you, I don't see a problem with what you are trying to do. I'll write a blog about this tomorrow night (or at lunch if I take one). Just to make sure that I understand what it is that you are asking... You have groups of "DDT", "SQR", "BTK", etc.. You want the the numbers withing DDT and then again in SQR?

Thanks,

Brian

10/8/2010
 · 
 
by
Blogs RSS Feed

briankmcdonald's latest blog posts

Blogs RSS Feed

Latest community blog posts