Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

ssrs,matrix reports

Posted on 2009-05-13
Medium Priority
622 Views
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
Question by:lavanyareddy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 27

Accepted Solution

Chris Luttrell earned 1000 total points
ID: 24380097
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

LVL 9

Assisted Solution

VikramMullick earned 1000 total points
ID: 24381808
0

Featured Post

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month4 days, 17 hours left to enroll