October 23, 2013 at 1:08 am
Hi All
I am trying to replicate the Excel Pie of Pie feature but I am struggling a bit.
I have managed to create the collected pie in ssrs but I am not happy with how it displays the numbers.
The first chart has a split of 63%, 19% and 19% then the 2nd chart has 38%, 19%, 5%, 5% and 33%.
I want the 2nd chart to reflect the original percentages of the categories.
Please see attachements.
The PieOfPie Excel file shows what I want to see which is basically the original values of the called out categories.
Thanks
October 24, 2013 at 3:41 am
Youl will need to adjust the label to not use #Percent and use an actual calculation of the detail value divided by the grouped value.
October 24, 2013 at 3:45 am
I used the #VALY but I have changed my chart to the normal because I noticed that the chart legend would have a number for the collected pie and I don't want that. The legend should just have the different categories.
Thanks
October 24, 2013 at 3:53 am
You can hide the legend.
October 24, 2013 at 3:59 am
I need it there, just not that collected figure to appear (please see attached).
October 24, 2013 at 4:03 am
to get the "sub percentages" you do need to change the label values formula. I would do that first and then see about removing that item from the legend.
October 25, 2013 at 9:00 am
SceloM:
I realize you're looking to improve your pie-of-pie display. Hopefully, various SSRS pros will be able to assist you to achieve your goal.
In the meantime I'd like to recommend an article about the weaknesses of using pie charts to display data. The article is written by Stephen Few, a data visualization expert:
Link: http://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf
If you're unable to create a pie-of-pie display to your satisfaction, consider the suggestions in the linked article mentioned above.
--Pete
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply