I want the pie chart to show sales per storefront as a percentage of the total. So if we have 3 storefronts with sales of $30, $30 and $40. I want to see 3 slices with 30%, 30% and 40%. I am able to make a table with the corresponding info but it won't convert to chart.

Answered by Asutosh Jha

Below are the steps you need to follow to create this requirement-

1. Store to rows
   
2. Sale to text
   
3. Show Me, select Pie
   
4. On left Marks Card, Angle icon, right-click and Add Table Calculation-Percent of Total