PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Saturday, April 23, 2022

[FIXED] How to percentage and count in SSRS Pie Chart

 April 23, 2022     pie-chart, reporting-services, ssrs-2008     No comments   

Issue

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 :-)



Answered By - Naveen Kumar
Answer Checked By - David Goodson (PHPFixing Volunteer)
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing