Solved

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

Posted on 2010-11-19
4
587 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Help 27 48
SQL Query - Database name 'TempDB' ignored, referencing object in tempdb - Error 2 18
replace \ by - in select 4 23
Job - date manual 1 24
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

825 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