Percent of total in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the percent of total sales for each category.

Tableau

SUM([Sales]) / [1]

Drag options to blanks, or click blank then click option'

AMIN([Sales])

BAVG([Sales])

CTOTAL(SUM([Sales]))

DCOUNT([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVG([Sales]) instead of TOTAL(SUM([Sales]))

Using COUNT([Sales]) which counts rows, not sums values

To calculate percent of total, divide the sum of sales by the total sum of sales across all categories using TOTAL(SUM([Sales])).

2fill in blank

medium

Complete the code to create a calculated field that shows percent of total profit by region.

Tableau

SUM([Profit]) / [1]

Drag options to blanks, or click blank then click option'

AAVG([Profit])

BSUM([Profit])

CMIN([Profit])

DWINDOW_SUM(SUM([Profit]))

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM([Profit]) which only sums for the current row

Using AVG([Profit]) which calculates average, not total

WINDOW_SUM(SUM([Profit])) calculates the total profit over the window, which is needed to compute percent of total.

3fill in blank

hard

Fix the error in the calculated field to correctly compute percent of total sales by segment.

Tableau

SUM([Sales]) / [1]

Drag options to blanks, or click blank then click option'

AWINDOW_SUM(SUM([Sales]))

BSUM([Sales])

CTOTAL(AVG([Sales]))

DAVG([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM([Sales]) in denominator which causes division by itself

Using AVG([Sales]) which does not represent total sales

WINDOW_SUM(SUM([Sales])) correctly computes the total sales over the window, enabling percent of total calculation.

4fill in blank

hard

Fill both blanks to calculate percent of total profit by category and region.

Tableau

SUM([Profit]) / [1]([2])

Drag options to blanks, or click blank then click option'

AWINDOW_SUM(SUM([Profit]))

BFIXED

CTOTAL

DINCLUDE

Attempts:

3 left

💡 Hint

Common Mistakes

Using FIXED or INCLUDE which are not appropriate for this calculation

Using SUM([Profit]) instead of WINDOW_SUM for total

Use WINDOW_SUM(SUM([Profit])) to get total profit in the window and TOTAL to aggregate correctly for percent of total.

5fill in blank

hard

Fill all three blanks to create a calculated field for percent of total sales by category with table calculation.

Tableau

SUM([Sales]) / [1]([2](SUM([Sales])), [3])

Drag options to blanks, or click blank then click option'

AWINDOW_SUM

BTOTAL

CALL

DPARTITION

Attempts:

3 left

💡 Hint

Common Mistakes

Using PARTITION instead of ALL which limits scope

Using WINDOW_SUM outside TOTAL which causes incorrect aggregation

Use TOTAL(WINDOW_SUM(SUM([Sales])), ALL) to compute total sales ignoring filters for percent of total.

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