SQL Server Reporting Services: creating a Pareto chart
- by william
I am trying to create a Pareto Chart in SQL Server Reporting Service 2005. I created a chart, but having difficulties in trying to get my cumulative(line) to display. I listed my values below.
=SUM(Fields!Total_SR.Value)/MAX(Fields!Total_SR.Value,
"SeriesGroup")*0.75
cumulative value:
=RunningValue(Fields!Total_SR,
Sum, "SeriesGroup") / Sum(Fields!Total_SR, "SeriesGroup")
I am able to get the Bar to display.
This is the instructions I used:
http://msdn.microsoft.com/en-us/library/aa964128(SQL.90).aspx