June 29, 2010 at 6:43 pm
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
Have you tried:
=Sum(Fields!total.Value)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 29, 2010 at 8:34 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply