|
|
|
|
SQL Reporting Services - Answers to your questions
| |
|
Author |
Thread:
Total by groups |
|
mxwebb
|
Total by groups
Posted:
Monday, April 02, 2007 7:35 PM (GST)
|
|
I am have my data grouped by the department then grouped by district.
Then I total each group I need a way to total the two groups now.
Auxliliary Life
1685 84
2509 18
3629 85
3836 77
4352 150
5559 37
7056 45
9365 184
9569 28
9785 291
9889 35
9978 63
9981 150
10002 11
10029 96
10041 121
10046 121
10221 50
10252 147
Total - DAK99 1793 -- END OF GROUP ONE
AK 23
Total - AK 23 -- NOTE I really need this total to be the total of GroupOne Total plus the (23) from Group two. (There will only be one record in this group!!!) So really now need to total it. -- END OF GROUP TWO
|
|
|
|
|
|
|
|
|