Percent of total in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does 'Percent of total' mean in Tableau?

It shows how much a part contributes to the whole, expressed as a percentage. For example, sales of one product compared to total sales.

beginner

How do you create a 'Percent of total' calculation in Tableau?

Use the table calculation 'Percent of Total' on a measure like sales. Right-click the measure, choose 'Quick Table Calculation', then select 'Percent of Total'.

intermediate

What is the difference between 'Percent of Total' and 'Running Total' in Tableau?

'Percent of Total' shows each part's share of the whole. 'Running Total' adds values cumulatively over a dimension like time.

intermediate

Why is it important to set the correct addressing and partitioning in 'Percent of Total' calculations?

Because it controls how Tableau sums and divides data. Wrong settings can give wrong percentages, like summing across wrong categories.

advanced

Can you create a 'Percent of Total' calculation using a calculated field in Tableau? How?

Yes. Use a formula like SUM([Sales]) / TOTAL(SUM([Sales])) to get each part's percent of total sales.

In Tableau, which menu option helps you quickly create a 'Percent of Total' calculation?

A Quick Table Calculation

B Create Calculated Field

C Data Source Filters

D Show Me

The 'Quick Table Calculation' menu lets you apply 'Percent of Total' easily on a measure.

What does the TOTAL() function do in a 'Percent of Total' calculated field?

A Calculates running total

B Filters data by category

C Calculates the sum over the entire partition

D Sorts data alphabetically

TOTAL() sums the measure over the whole partition, used as the denominator in percent calculations.

If your 'Percent of Total' values add up to more than 100%, what is likely wrong?

A You used the wrong color palette

B Data source is corrupted

C You forgot to refresh the data

D Incorrect addressing or partitioning in table calculation

Wrong addressing or partitioning causes Tableau to calculate percentages over wrong groups.

Which of these is NOT a use case for 'Percent of Total' in Tableau?

A Showing each product's sales share

B Comparing cumulative sales over time

C Visualizing market share

D Analyzing category contribution

'Comparing cumulative sales over time' is better done with running total, not percent of total.

How can you check if your 'Percent of Total' calculation is correct?

A Sum the percentages; they should be close to 100%

B Check if all values are zero

C Look for negative percentages

D Verify if the colors are bright

Percent of total values should sum to 100% across the partition.

Explain how to create a 'Percent of Total' visualization in Tableau and why it is useful.

Think about how sales of one product compare to total sales.

Describe the importance of addressing and partitioning settings when using 'Percent of Total' in Tableau.

Imagine calculating percent of total sales by region vs. by product.

Practice

1. What does the "Percent of total" calculation show in Tableau?

easy

A. Each part's share of the whole

B. The total sum of all measures

C. The difference between two measures

D. The average value of a measure

Solution

1. Step 1: Understand the meaning of percent of total

   Percent of total shows how much each part contributes to the entire total.

2. Step 2: Relate to Tableau usage

   In Tableau, this is used to see the share of each category or item compared to the whole dataset.

3. Final Answer:

   Each part's share of the whole -> Option A

4. Quick Check:

   Percent of total = part / whole [OK]

Hint: Percent of total means part divided by whole [OK]

Common Mistakes:

• Confusing percent of total with sum
• Thinking it shows difference instead of share
• Mixing average with percent of total

2. Which of the following is the correct Tableau formula to calculate percent of total for a measure named Sales?

easy

A. SUM([Sales]) / TOTAL(SUM([Sales]))

B. TOTAL(SUM([Sales])) / SUM([Sales])

C. SUM([Sales]) * TOTAL(SUM([Sales]))

D. SUM([Sales]) - TOTAL(SUM([Sales]))

Solution

1. Step 1: Identify the correct formula structure

   The percent of total is calculated by dividing the sum of the part by the total sum.

2. Step 2: Match with Tableau syntax

   In Tableau, TOTAL() wraps the aggregation to get the grand total, so SUM([Sales]) / TOTAL(SUM([Sales])) is correct.

3. Final Answer:

   SUM([Sales]) / TOTAL(SUM([Sales])) -> Option A

4. Quick Check:

   Part / Total = SUM / TOTAL(SUM) [OK]

Hint: Divide SUM by TOTAL(SUM) for percent of total [OK]

Common Mistakes:

• Reversing numerator and denominator
• Using multiplication instead of division
• Subtracting instead of dividing

3. Given a dataset with categories A=100, B=300, and C=600 sales, what is the percent of total for category B using SUM([Sales]) / TOTAL(SUM([Sales]))?

medium

A. 10%

B. 30%

C. 60%

D. 50%

Solution

1. Step 1: Calculate total sales

   Total sales = 100 + 300 + 600 = 1000.

2. Step 2: Calculate percent of total for category B

   Percent = 300 / 1000 = 0.3 or 30%.

3. Final Answer:

   30% -> Option B

4. Quick Check:

   300 / 1000 = 0.3 = 30% [OK]

Hint: Divide category value by total sum, then convert to percent [OK]

Common Mistakes:

• Adding instead of dividing
• Using wrong total value
• Confusing category values

4. You wrote the formula SUM([Sales]) / TOTAL(SUM(Sales)) but Tableau shows an error. What is the problem?

medium

A. Using SUM instead of AVG

B. Division operator is incorrect

C. TOTAL function cannot be used with SUM

D. Missing square brackets around Sales in TOTAL function

Solution

1. Step 1: Check syntax of field references

   In Tableau, field names must be enclosed in square brackets inside functions.

2. Step 2: Identify missing brackets in TOTAL function

   The formula uses TOTAL(SUM(Sales)) but should be TOTAL(SUM([Sales])).

3. Final Answer:

   Missing square brackets around Sales in TOTAL function -> Option D

4. Quick Check:

   Field names need [ ] in functions [OK]

Hint: Always use [ ] around field names inside functions [OK]

Common Mistakes:

• Omitting brackets around field names
• Using wrong aggregation functions
• Incorrect operator usage

5. You want to show the percent of total sales by region in a bar chart. Which steps correctly apply this in Tableau?

hard

A. Create a calculated field: TOTAL(SUM([Sales])) / SUM([Sales]), then use Region on Rows

B. Use SUM([Sales]) only, then sort bars descending

C. Create a calculated field: SUM([Sales]) / TOTAL(SUM([Sales])), format as percentage, then use Region on Columns and this field on Rows

D. Create a calculated field: SUM([Sales]) - TOTAL(SUM([Sales])), then use Region on Columns

Solution

1. Step 1: Write correct percent of total formula

   Use SUM([Sales]) / TOTAL(SUM([Sales])) to get each region's share.

2. Step 2: Build the visualization

   Place Region on Columns and the calculated percent field on Rows, then format as percentage for clarity.

3. Final Answer:

   Create a calculated field: SUM([Sales]) / TOTAL(SUM([Sales])), format as percentage, then use Region on Columns and this field on Rows -> Option C

4. Quick Check:

   Percent of total formula + proper chart setup [OK]

Hint: Divide SUM by TOTAL(SUM), format %, use region on axis [OK]

Common Mistakes:

• Using subtraction instead of division
• Reversing numerator and denominator
• Not formatting as percentage