Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cseward
Starting Member
24 Posts |
 Posted - 2014-12-08 : 12:09:37
|
| I have 2 column groups and 1 row group. The row group is month. the first column group is school year and the second is discipline. I want to subtotal the monthly disciplines by school year. When I add a total for school year, I get a total for all disciplines for both school years at the end of the row. I want to paste an excel picture of the results that I get and an excel picture of what I WANT to get so you can see. Is there a way to attach an excel document to a post ??Please help.Thx in advance. |
|
|
cseward
Starting Member
24 Posts |
Posted - 2014-12-08 : 12:19:08
|
| I figured it out. I needed to add the total to the discipline column group and not the school year column group. |
 |
|
|
|
|
|
Matrix column group subtotals