none
How to Calculate Subtotal of Rows & Colums in Matrix Reports in Reporting Services (SSRS 2005) RRS feed

  • Question

  • Hi All,

    How to Calculate Subtotal of Rows & Colums in Matrix Reports in Reporting Services (SSRS 2005).
    Can anyone can share on this ?

    Thanks in Advance.

    Regards,
    Rahul
    Thursday, December 11, 2008 5:26 AM

Answers

  •  Hi Rahul,

    First, please make sure that the expression in the matrix cell uses an aggregate function, e.g.: =Sum(Fields!Revenue.Value)

    Then, right click on the corresponding column header or row header of the matrix, and select "Add Subtotal" from the context menu.

    -- Robert


    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, December 30, 2008 5:51 PM
    Moderator