Solved

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

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Calculated columns 13 60
Solution for warm standby SQL server 20 34
MS SQLK Server multi-part identifier cannot be bound 5 25
TSQL - IF ELSE? 3 25
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

943 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

10 Experts available now in Live!

Get 1:1 Help Now