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,
Elizabeth
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.
]]>