0
0
Tableaubi_tool

Pie charts in Tableau - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Concept Flow
Category | Sales
---------|-------
Books    | 300
Electronics | 500
Clothing | 200
Furniture | 100

Total Sales = SUM(Sales) = 1100

Each slice = Sales / Total Sales
We start with sales data by category. We sum all sales to get total sales. Then, for each category, we calculate its share by dividing its sales by total sales. This share determines the size of each pie slice.
Formula
SUM([Sales]) = 300 + 500 + 200 + 100 = 1100 Books share = 300 / 1100 = 0.2727 Electronics share = 500 / 1100 = 0.4545 Clothing share = 200 / 1100 = 0.1818 Furniture share = 100 / 1100 = 0.0909

This shows the calculation steps to find total sales and each category's share for the pie chart.

Step-by-Step Trace
CategorySalesTotal SalesShare
Books30011000.2727
Electronics50011000.4545
Clothing20011000.1818
Furniture10011000.0909
The 'Share' column shows the fraction of total sales each category represents, which is used to draw the pie slices.
Variable Tracker
VariableValue
Total Sales1100
Books Share0.2727
Electronics Share0.4545
Clothing Share0.1818
Furniture Share0.0909
Key Moments
What is the total sales value used for the pie chart?
How is the size of each pie slice determined?
What share does Electronics have in the pie chart?
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula SUM([Sales]) calculate?
AThe sales of a single category
BThe total sales across all categories
CThe average sales per category
DThe difference between highest and lowest sales
Key Result
Pie charts show parts of a whole by dividing a circle into slices sized by each part's share of the total.
Transcript
We start with sales data by category. We add all sales to get total sales. Then, for each category, we divide its sales by total sales to find its share. This share determines the size of the pie slice. For example, Books sales are 300, total sales are 1100, so Books share is 300 divided by 1100, about 27%. Electronics has the largest share at 45%. Furniture has the smallest at 9%. These shares create the pie chart slices.