How to we display percentage in pie chart SSRS

reporting-servicesssrs-2008

I have a Pie Chart in SSRS which has 4 Sectors with some number on them,i was planning to display percentages rather than displaying numbers.I tried Clicking on the Series Label properties and set the Label Data as #Percent.but percentage is displaying for only one sector and numbers to other sectors.

How can i display percentages for all the sectors?

Best Answer

By default, the Series Label will return the Value for the Series. You can set it to format as a Percentage, but if the Value is 1, it is going to display 100%. To get the percentage Value over the Total Value, you'll need to modify the Label Data formula under the Series Label Properties.

  1. Right Click the Series Label on your Chart.
  2. Select Series Label Properties.
  3. Enter this formula into the Label Data box, replacing your actual field and dataset names:

=sum(Fields.YourValue.Value)/sum(Fields.YourValue.Value,"YourDataSet")

Make sure you have selected "Percentage" under the Number Category on the Series Label Properties.

Let me know if you need more detail.

Related Topic