SQL Server Performance Forum – Threads Archive
How to Add Column in Matrix Table
i have problem how to insert the total between the another division .. can someone help me<br /><br /><img src=’http://www24.brinkster.com/alumnismkap/matrix.bmp’ border=’0′ /><br /><br />it is because i want total for every division .Please refer to the link images. thanksWhat is the problem in inserting the column, with BIDS you can define and what is the type of report you are chosing. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
As per my understanding of your requirement, here is my answers:
1. If you want to see the total at the bottom of the column for all rows, right click on the first row,first item and select SubTotal.
For Ex:
Desc X Y Z
a 2 3 4
b 21 31 41
Total 23 33 44 2. If you want to see the total in the right most column for all columns, right click on the first Column,first item and select SubTotal.
For Ex:
Desc X Y Z Total
a 2 3 4 9
b 21 31 41 93
I hope This helps for you. If not, try to take advantage of msdn tutorials and lok for SubTotals, which can help better with more details. Thiru
]]>