SQL Server Performance

How to Add Column in Matrix Table

Discussion in 'SQL Server 2005 Reporting Services' started by azfiza, Jan 30, 2007.

  1. azfiza New Member

    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. thanks
  2. satya Moderator

    What 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.
  3. Thirusspforum New Member

    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

Share This Page