[Webinar] Streamline your web hosting managementRegister Today

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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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