Tuesday, February 23, 2010

Programmer - Pareto chart SS 2005

Programmer Question

I am trying to create a Pareto Chart in SS 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

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails