Matrix Totals | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Matrix Totals

Hello all, My first SSRS Matrix report and I want to show both row and column $ subtotals. Online I found info that said right click the column and select subtotal. When I right click the options are ‘Add Row Group’ or ‘Add Column Group’ but no subtotals option. I tried adding a group but did get the desired results. Am I missing some detail for getting to the subtotals option? The matrix detail cell value says "=Sum(Fields!Sum_of_Margin.Value)" Thanks,
The solution… right click in the first field of the detail column 100 times until you get a shortcut menu that shows the Subtotal option. It’s there but hidden if the background color is dark green <img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ /> <br /><br /><br />Thanks.

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |