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.
Below are the steps you need to follow to create this requirement-
- Store to rows
- Sale to text
- Show Me, select Pie
- On left Marks Card, Angle icon, right-click and Add Table Calculation-Percent of Total
