Percent of total in Tableau - Step-by-Step Guide

Introduction

This feature helps you show how much each part contributes to the whole. It solves the problem of understanding proportions in your data, like what percent of total sales each product has.

When you want to see what percent each region contributes to total sales on a dashboard

When you need to compare each product's share of total revenue in a bar chart

When showing the percentage breakdown of expenses in a pie chart

When analyzing the share of each salesperson's sales compared to the team total

When you want to highlight the contribution of each category in a stacked bar chart

Steps

Step 1: Open your Tableau workbook and go to the worksheet with your data

- Tableau workspace

You see your data fields and current visualization

💡 Make sure your data is connected and loaded

Step 2: Drag the measure you want to analyze (e.g., Sales) to the Rows or Columns shelf

- Rows or Columns shelf

A basic chart showing total sales appears

💡 Use a bar chart for clear percent of total visualization

Step 3: Drag the dimension you want to break down by (e.g., Region) to the opposite shelf or Color on Marks card

- Columns shelf or Marks card > Color

The chart splits sales by each region

💡 This groups your data for percent calculation

Step 4: Right-click the measure on the shelf and select 'Quick Table Calculation' > 'Percent of Total'

- Measure pill on Rows or Columns shelf

Values change to show each part's percent of the total

💡 Tableau automatically calculates percent of total

Step 5: Click the measure pill again and choose 'Edit Table Calculation' to adjust direction if needed

- Measure pill > Edit Table Calculation

You can set calculation to compute across table, down, or specific dimensions

💡 Adjust this to get correct percent based on your layout

Step 6: Add labels by dragging the measure to Label on the Marks card

- Marks card > Label

Percent values appear on the chart for easy reading

💡 Format labels as percent for clarity

Before vs After

Before

Bar chart shows total sales by region with raw sales numbers like 50000, 30000, 20000

After

Bar chart shows sales by region as percentages like 50%, 30%, 20% of total sales

Settings Reference

Quick Table Calculation

📍 Right-click measure pill on Rows or Columns shelf

Apply common calculations quickly to your data

Default: None

Edit Table Calculation

📍 Right-click measure pill > Edit Table Calculation

Customize how the percent of total is calculated across your data

Default: Table Across

Label Formatting

📍 Marks card > Label > Format

Display percent values clearly on the visualization

Default: Automatic

Common Mistakes

Not setting the correct direction in 'Edit Table Calculation'

Percent of total calculates incorrectly if direction does not match data layout

Use 'Compute Using' options to match how your data is arranged, e.g., Table Across for horizontal layout

Applying percent of total on a dimension instead of a measure

Percent of total only works on numeric measures, not categories

Always apply percent of total on a measure like Sales or Quantity

Summary

Percent Of Total shows each part's share of the whole in your data.

Use Quick Table Calculation to apply it easily on measures.

Adjust calculation direction to match your data layout for accurate results.

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