How to show percentage in pie chart?

LilCLilC MemberPosts:24Learner I
edited July 2020 inHelp
I have 2 different groups in the pie chart and the results are aggregated.
I want to show the percentage of each group's sales, instead of the sum of the sales.



Also, if I use Marco to calculate the percentage of each store, how can I display both the sales and the percentage in the result (not the chart)?

Can anyone help me with it?
Tagged:

Best Answers

  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University ProfessorPosts:1,984RM Engineering
    Solution Accepted
    Hi,

    No, Sunburst does not support %. I suppose because it is usually very crowded with dozens of elements..
    Regarding your other question, the available space is determined by the library. I would assume it thinks there is not enough space and therefore does not show those anymore. You have too many small elements in the same space for the labels to be shown properly in a pie chart, if you ask me. Those would make the chart not very nice, even if they did fit on the screen.

    Regards,
    Marco
    LilC

Answers

  • LilCLilC MemberPosts:24Learner I
    edited July 2020
    Hi, Marco, if it is for Sunburst chart, will it work as well?
    Also, since some are less than 0.9% of the total, if there any way to display them as well?
  • LilCLilC MemberPosts:24Learner I
    edited July 2020
    Thanks, Marco, you are awesome.
    Because I really need to show those top 10 stores' individual percentage.
    Is there a way to display them on the side of the bar chart?

    If not I'll just use macro to add a column.
  • Loan_Nguyen56Loan_Nguyen56 MemberPosts:8Contributor II
    I want to show that in Rapid, please hep me. Thanks.

Sign InorRegisterto comment.