Post reply

subtotal

  • June 29, 2010 at 6:43 pm

    #226272

    Hi,

    I am new to SSRS2008. I have to calculate total based on calculated value in Matrix.

    Example:

    06/21/2010 06/22/2010 total

    new jersey 21--count(companyNum) 2 23

    newyork 12 1 13

    texas 3 3 6

    In Above example...

    I have to calculate "total" column. how to calculate? Please help.

    Thanks,

    BMR

  • June 29, 2010 at 7:44 pm

    #1186809

    Have you tried:

    =Sum(Fields!total.Value)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • June 29, 2010 at 8:34 pm

    #1186818

    06/21/2010 6/22/2010

    new jersey21-- count(companyNum) in expression2

    newyork 12 1

    texas 3 3

    In above table, count(companyNum) in expression. I need a “Total” column or “SubTotal” column. It should have sum of all column.

    Eample

    21+2 = 23

    12+1=13

    3+3=6

    Thanks,

    BMR

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply