Search code examples
reporting-servicesssrs-2008pie-chart

How to percentage and count in SSRS Pie Chart

I have a Pie chart generated using SSRS. I would like to Show both Count and percentage in the Pie chart.

Right now, I am able yo show the count in pie charts as well as in the report.

I want to show the name of the partition and also the percentage directly pointed out.

Example :

ALD 38% 56

please help me withe properties to do it.

I'm using VS 2008

Solution

  • write down an expression on series label data like -

    =Sum(Fields!DATA.Value, "Chart1_SeriesGroup1") & "("  
    &  Sum(Fields!DATA.Value, "Chart1_SeriesGroup1")  * 100 /Sum(Fields!DATA.Value, "DataSet1") 
    & "%)"

    Here Chart1_SeriesGroup1 is the group name if you look at series group setting

    enter image description here

    Here DataSet1 is the name of Dataset

    Here is the final output

    enter image description here

    Cheers :-)