SQL Server Reporting Services: Creating a Pareto Chart

Question

I am trying to create a Pareto chart in SQL Server Reporting Service 2005. I have created a chart, but am having difficulty trying to display my cumulative (row). I have listed my meanings below.

= SUM (Fields! Total_SR.Value) / MAX (Fields! Total_SR.Value, "SeriesGroup") * 0.75

total value:

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

I can make the panel display.

These are the instructions I used:

http://msdn.microsoft.com/en-us/library/aa964128(SQL.90).aspx

Answer 1

Michael J Swart - http://michaeljswart.com/2008/10/reporting-services-is-fun-again%E2%80%A6/

Answer 2

- ( .Value):

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