SQL Server Reporting Services: creating a Pareto chart
Posted
by william
on Stack Overflow
See other posts from Stack Overflow
or by william
Published on 2010-02-23T20:52:46Z
Indexed on
2010/04/13
21:43 UTC
Read the original article
Hit count: 338
sql-server-2005
|reporting-services
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
© Stack Overflow or respective owner
