Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 subtotal Rate Topic Display Mode Topic Options
Author
 Message
 Posted Tuesday, June 29, 2010 6:43 PM
 SSC Journeyman Group: General Forum Members Last Login: Monday, March 16, 2015 7:55 AM Points: 85, Visits: 398
 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 23newyork 12 1 13texas 3 3 6In 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 Group: General Forum Members Last Login: Yesterday @ 8:06 AM Points: 5,913, Visits: 10,371
 Have you tried:`=Sum(Fields!total.Value)` WayneMicrosoft Certified Master: SQL Server 2008Author - SQL Server T-SQL RecipesIf 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 Group: General Forum Members Last Login: Monday, March 16, 2015 7:55 AM Points: 85, Visits: 398
 06/21/2010 6/22/2010new jersey 21-- count(companyNum) in expression 2newyork 12 1texas 3 3In above table, count(companyNum) in expression. I need a “Total” column or “SubTotal” column. It should have sum of all column.Eample 21+2 = 2312+1=133+3=6Thanks,BMR
Post #945158

 Permissions