Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 669
  • Last Modified:

ssrs,matrix reports

hi,
I just want to calculate the pecentages in matrix reports.Is there any one who could tell me how to calculate percentages in matrix reports .

thank you
0
lavanyareddy
Asked:
lavanyareddy
2 Solutions
 
Chris LuttrellSenior Database ArchitectCommented:
you will probably want to use something like this to calculate the percent a value is over a total in a given scope.
=Fields!SomeField.Value/Sum(Fields!SomeField.Value,"*Scope*")
where *Scope* is the name of a grouping scope, like a matrix column or row depending on where you want the percent.
You did not give much deatail so I can not be very specific in my example.
You might want to check out this for more on understanding Scope in RS http://msdn.microsoft.com/en-us/library/ms159673.aspx
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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