I am able to show the value but the % are coming in another column . Please suggest how to show that.
Might just be me, but I can't see an attachment
Me neither.
I just took a look at the original post, and there are no attachments and no hidden links, so you're not missing anything Chris or Lynn.
All I can suggest is the old Cognos message you'd get from Quiz if you tried to run a Quiz report containing graphics terminal plot commands on a non-graphics terminal...
"Imagine a circle..."
MF.
(https://68.media.tumblr.com/220ae90bf26fcd6595221af77c3f08a2/tumblr_on3f35ulyj1w2f2gfo1_400.gif)
I feel slightly giddy! :)
I'm also having trouble reading the % values on that one, Lynn! :D
MF.
I suddenly have a strong desire to cluck like a chicken...and I seem to have lost the last 10 minutes, ever since I opened Lynn's post.
Sorry of not attaching the image. I have attached now
It seems rather appropriate that my 1000th post is about pie charts ;). I'm an advocate of the Stephen Few approach to pie charts, in other words I almost exclusively avoid them. If you haven't read his article, it explains much more eloquently than I can the reasons why other formats work better:
https://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf (https://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf)
I've taken the figures from your attachment and produced two very quick formats, both of which I'd argue are easier to read than your 3D pie chart...take a look and see what you think.
Quote from: BigChris on 18 May 2017 03:27:39 AM
I've taken the figures from your attachment and produced two very quick formats, both of which I'd argue are easier to read than your 3D pie chart...take a look and see what you think.
Booo! Booo! Booo! Can't even do simple math! Your percentages don't add up to 100! Booo!
(scnr.... :D)
QuoteYour percentages don't add up to 100! Booo!
LOL - that's the risk of using Excel and letting it round to the nearest whole % figure
Aaaaaaaanyways... to answer the OP's question:
Don't try to put two measures into the crosstab. Just, in the piechart's properties, find "chart labels", and set it up like shown in the screenshot attached.
Disclaimer: By answering this question, hespora takes no responsibility for poor business decisions that are rooted in faulty understanding of data due to the usage of piecharts. I do not condone the usage of piecharts, and answering this question can not be construed as such. Use at your own risk, and seriously, read that essay that BigChris linked.
Quote from: BigChris on 18 May 2017 04:42:27 AM
LOL - that's the risk of using Excel and letting it round to the nearest whole % figure
Yea, I figured that. But I guess we all will have had some business user yell at us for that exact reason... ;)