Problem adding rows/column in a matrix | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Problem adding rows/column in a matrixI have no problem doing this in a table format, however I can’t seem to get column/rows to add up in a matrix format. It’s a completely different scenario when you do this. Is there access to some sort of Row and Column objects for each render where I can set a
Sum() function ?? Thanks for any advice !
I must admit I’m not very sure what you’re talking about [<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />] Do you mean adding subtotal rows/columns or do you mean for example adding an extra column on the right of an existing matrix to show a grand total for a row ?<br /><br />HTH<br /><br />Jasper Smith
Exactly Jasper, sorry I was a little unclear in my question, but yes, adding an extra column on the right of an existing matrix to show a grand total for a row .
If we take the Company Sales report that is in the Sample Project, you can add a total column to the right of the existing matrix by simply right clicking the OrderYear textbox (top right cell in the matrix) and choosing SubTotal. You will now have a new column on the right of the matrix that has the Total for the rows and will keep displaying the correct row total as you expand the various groups in the report.Hope this is what you mean [<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />]<br /><br />HTH<br /><br />Jasper Smith
that’s exactly what I was looking for, thanks !