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.
=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.