Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

subtotal Expand / Collapse
Author
Message
Posted Tuesday, June 29, 2010 6:43 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:12 AM
Points: 85, Visits: 382
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
Post #945137
Posted Tuesday, June 29, 2010 7:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:48 AM
Points: 5,366, Visits: 8,977
Have you tried:
=Sum(Fields!total.Value)



Wayne
Microsoft Certified Master: SQL Server 2008
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #945149
Posted Tuesday, June 29, 2010 8:34 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:12 AM
Points: 85, Visits: 382
06/21/2010 6/22/2010
new jersey 21-- count(companyNum) in expression 2
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
Post #945158
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse