Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 641
  • 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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