SQL Server Reporting Services: creating a Pareto chart

Question

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

Answer 1

Shouldn't it be something like the following (with the .Value):

=RunningValue(Fields!Total_SR.Value, Sum, "SeriesGroup") / Sum(Fields!Total_SR.Value, "SeriesGroup")