Tableau-Desktop-Found Exploring and Analyzing Data Practice Question
Exhibit
Error: Cannot aggregate the aggregate expression. Calculation: SUM(SUM([Sales]) / [Profit])
Refer to the exhibit. Why does this calculation error occur in Tableau?
⚠ Common exam trap
Candidates often forget the fundamental rule of aggregation. They attempt to mix raw row-level data with aggregated sums, failing to realize that Tableau requires all fields in an expression to be at the same level.
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 calculation mixes aggregated and non-aggregated fields in an incompatible way.
The error occurs because you are attempting to perform an operation on an already aggregated field. 'SUM([Sales])' returns a single aggregate, and 'Profit' is a raw measure; dividing an aggregate by a non-aggregate creates a mix of aggregation levels. Tableau requires all components in an expression to have the same level of aggregation, ensuring calculations are mathematically sound and consistent across the entire dataset during exploration.
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 field 'Profit' must be converted to a dimension before it can be used in a calculation.
Why it's wrong here
Converting a measure to a dimension does not solve aggregation errors in calculations. The issue is about the mathematical consistency of the formula, not the data type or role (measure vs. dimension). You must wrap the non-aggregated fields in an aggregation function like SUM() or ATTR() to fix this.
- ✗
You cannot divide a measure by another measure in Tableau.
Why it's wrong here
Tableau fully supports division between measures. The problem in the exhibit is specifically the mismatch between the aggregated 'SUM(Sales)' and the non-aggregated 'Profit'. By simply aggregating 'Profit' as 'SUM(Profit)', the formula would become valid because both sides of the division operator would then be at the same level.
- ✓
The calculation mixes aggregated and non-aggregated fields in an incompatible way.
Why this is correct
Tableau requires consistent aggregation levels in expressions. 'SUM([Sales])' is an aggregate, but 'Profit' is not. When you combine them, Tableau throws an error because it cannot perform the calculation at two different levels simultaneously. Every field in the formula must be aggregated to achieve the desired row-level or view-level result.
- ✗
The calculation is attempting to use a field that has been filtered out of the view.
Why it's wrong here
Filtering does not prevent you from using a field in a calculation expression. The error is syntactic and logical regarding aggregation levels. Even if the field is present, the calculation logic is invalid. Filtering affects the data scope, whereas this error affects the integrity of the formula structure itself.
About these practice questions
This Tableau-Desktop-Found question is part of Courseiva's 126-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.