Solved

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

Posted on 2010-11-19
4
592 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
ID: 34174770
I will recommend that add a computed field in the dataset.
0
 
LVL 4

Expert Comment

by:BostonMA
ID: 34175068
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
ID: 34176943
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
ID: 34176986
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

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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.

749 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