• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 607
  • Last Modified:

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

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
thedeltacompanies
Asked:
thedeltacompanies
  • 2
2 Solutions
 
devlab2012Commented:
I will recommend that add a computed field in the dataset.
0
 
BostonMACommented:
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
 
thedeltacompaniesAuthor Commented:
How do I add the computed field in a matrix in ssrs 2005.  I understand the calculation.
0
 
BostonMACommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now