Question for CHART Experts: How to show Percentages? -- sql server reporting services

neokortex
5/18/2005 11:42:07 AM

We want a PIE chart to show the PERCENTAGE of each TYPE of a particular
product for all the orders in a dataset. How do we get at the TOTAL number
of orders in the dataset? When editing Chart properties. the VALUES editor on
the DATA tab seems to apply only per category, which does not lend itself to
calculating by the SUM of a field in the entrie dataset. What are the best
ways of going about this? Is the a chart property forthis? Add a SUMMARY

Robert Bruckner [MSFT]
5/18/2005 12:25:48 PM

Assuming there is a field "A" which represents the values you want to show
in the pie chart, you can calculate the percentages by using e.g. a formula
for the datapoint label expression:
=Sum(Fields!A.Value) / Sum(Fields!A.Value, "DataSetName")

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server reporting services : Question for CHART Experts: How to show Percentages?