Solved

Reporting Services 2005: Adding Total footer to bottom of matrix

Posted on 2006-07-21
Medium Priority
15,566 Views
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
Question by:RepriseMIS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 2

LVL 14

Expert Comment

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

Author Comment

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

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

simon_kirk earned 1500 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

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
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…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month9 days, 20 hours left to enroll

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

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