Tableau-Desktop-Found Exploring and Analyzing Data Practice Question
Exhibit
{
"field": "Sales",
"aggregation": "SUM",
"viz_type": "Discrete Bar Chart",
"error_log": "Cannot show total for non-additive measure"
}Refer to the exhibit. You are trying to show a 'Grand Total' on a bar chart that uses an aggregate calculation. Why might this be failing?
⚠ Common exam trap
Candidates assume 'Grand Total' simply adds up whatever is on the screen. They fail to realize that for non-additive measures, Tableau cannot mathematically sum the displayed percentages or distinct counts.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The measure is a non-additive calculation, such as a ratio or distinct count.
Grand totals operate by re-calculating the sum at a higher level of aggregation. If the measure is a non-additive aggregate (like a ratio or a distinct count), Tableau cannot perform a simple sum of the displayed values to reach the total. You must ensure that the total is calculated by aggregating the underlying base data rather than the derived values displayed in the view.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The measure is a non-additive calculation, such as a ratio or distinct count.
Why this is correct
Non-additive measures, like percentages or distinct counts, cannot simply be summed. For example, adding the percentages of two separate groups does not result in the correct global percentage. Tableau correctly prevents a simple sum, as it would be statistically invalid, and requires a different approach for totals.
- ✗
The visualization uses a dual axis, which disables the Grand Total option.
Why it's wrong here
Dual axis charts do not inherently disable grand totals. While they can be complex to format, they still support total calculations if the underlying measures are additive. The error message explicitly mentions 'non-additive,' pointing to a problem with the measure's data nature rather than the visualization layout type.
- ✗
The data source has a circular reference in the relationship model.
Why it's wrong here
Circular references affect data blending and model performance, but they do not cause specific errors regarding the additive nature of a measure in a grand total calculation. The error provided focuses on the measure's properties, not the structure of the underlying data model or the relationships.
- ✗
The 'Grand Total' feature is only available for crosstab visualizations.
Why it's wrong here
Tableau supports grand totals for bar charts, scatter plots, and various other visualization types, not just crosstabs. This statement is factually incorrect regarding the software's capabilities. The issue is definitively linked to the measure's inability to be summed, not the type of visualization being used to display it.
About these practice questions
Courseiva writes every Tableau-Desktop-Found question from scratch — 126 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.