<div>
Right click the cell you wish to total and select Sub Total
</div>


Right click the cell you wish to total and select Sub Total

<div>
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. 
</div>


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.

<div>
as a workaround, you can sum up all other counts, like<br />
<br />
=Count( Fields!val1.Value ) + Count( Fields!val2.Value ) + ... + Count( Fields!valN.Value )<br />
<br />
regs,<br />
yurich
</div>


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

<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

Reporting Services 2005: Adding Total footer to bottom of matrix

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.