Solved

How can I add a calculated column to a ssrs 2005 matrix report

Posted on 2010-11-19
4
582 Views
Last Modified: 2012-05-10
I need to calcuate varian on SSRS 2005 matrix report.  Example below:


Salesperson     GMGoal   JobType1GM   JobType2GM   JobType3GM   Variance  
John Doe           10000          1000                  2500             3500                 -3000
                                                                                                                 

Formula in Variance field is  (GMGoal-JobType1GM-JobType2GM-JobType3GM)* (-1 )
0
Comment
Question by:thedeltacompanies
  • 2
4 Comments
 
LVL 13

Assisted Solution

by:devlab2012
devlab2012 earned 100 total points
Comment Utility
I will recommend that add a computed field in the dataset.
0
 
LVL 4

Expert Comment

by:BostonMA
Comment Utility
Or you can add it as a caluated field inside SSRS. The calculation is straight forward.  What exactly do you  need help with, the formula or the adding of the computed field?
0
 

Author Comment

by:thedeltacompanies
Comment Utility
How do I add the computed field in a matrix in ssrs 2005.  I understand the calculation.
0
 
LVL 4

Accepted Solution

by:
BostonMA earned 400 total points
Comment Utility
In your data set right click on a field, and then click add, and then click computed field and fill in the formula.  See screen shot.
example-computed-field.JPG
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now