Multiple labels in pie chart

Question

How to show % of total and actual value (actual division for each part)? i want to show each category in % and also as sales of each part divide by total sales.

Answer 1

Hi Rubia,

You can add multiple labels in a pie chart.

1. Select the fields (dimension and measure) that you want to show and select the pie chart.

2. Now to show % in the pie chart,

Create a calculated field as 

SUM([Sales]) / { SUM([Sales]) }

or Add Quick Calculation and select % of the total.

4. Drop the above field in label shelf to show the actual values in the pie chart along with % in the pie chart.

Hope it helps you.