Solved

Reporting Services 2005: Adding Total footer to bottom of matrix

Posted on 2006-07-21
4
15,543 Views
Last Modified: 2011-10-03
i have a matrix that has a series of row groups, and then a few column groups with the data that i am pivoting. what i am trying to do is get the Sum of the data in the row groups and display it across the bottom of the matrix. the matrix control doesnt let you add a footer like the table control does. is there a way to do this or am i out of luck?
0
Comment
Question by:RepriseMIS
  • 2
4 Comments
 
LVL 14

Expert Comment

by:simon_kirk
ID: 17162757
Right click the cell you wish to total and select Sub Total
0
 

Author Comment

by:RepriseMIS
ID: 17162897
I've tried that, and it does the sub total for each row, not for the total of the entire matrix. What im looking for is a bottom line grand total for all columns in the matrix.
0
 
LVL 21

Expert Comment

by:Yurich
ID: 17164084
as a workaround, you can sum up all other counts, like

=Count( Fields!val1.Value ) + Count( Fields!val2.Value ) + ... + Count( Fields!valN.Value )

regs,
yurich
0
 
LVL 14

Accepted Solution

by:
simon_kirk earned 500 total points
ID: 17166720
If you add a subtotal for the Column AND Row, then the Column totals should be totaled as a row grand total.  e.g.

                  ColumnType1        ColumnType2    TOTAL
RowType1              100                      320          420
RowType2              250                      400          650
TOTAL                   350                      720         1070 <---- Grand Total
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now