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.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Matrix column group subtotals

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.
Go to Top of Page
   

- Advertisement -