How to add % of total in Pie chart?

[#1]

Hi There,

In the Pie chart, can display the categories of absolute values, I want to add percentage of total.

Thank you in advance!

[awhitfield]

HI bing bin,

you could do something like the attached:

Remove the Demand Qty dimension and add it as Text In Chart, then change you expression to display as relative

HTH

Andy

[sunilkumarqv]

Hi bing ,

check attached

[#4]

Hi Andy,

thank you for your help.

since I am a beginner, could you please tell me the specific action steps with images?

thank you in advance!

[awhitfield]

Hi bing bin,

1. Open Chart Properties> Dimension and remove the Demand Qty Dimension.

2. Open Expressions and click relative, this enables the % values in the Legend

3. Open Presentation > Text In Chart > Add, enter the following in the Text field:

'TOTAL DEMAND QTY: ' & Sum([DEMAND QTY])

click Font and set the font size and bold if required

4. Use the keystrokes CTRL+Shift, red lines will appear around the various elements of the chart, keep them pressed and click and drag the 'text in chart' to the desired location.

Andy

[#6]

Hi Andy,

I got it, thank you so much for help!

[awhitfield]

HI Bing Bin,

glad I could help, if you are happy with the reply, please mark it as CORRECT

This helps other community members!

Andy