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.