Tableau Desktop Specialist — Question 131

Which function should a Data Analyst use to aggregate total regional sales for a dataset regardless of what is in the view?

Answer options

• A. SUM
• B. EXCLUDE
• C. FIXED
• D. INCLUDE

Correct answer: C

Explanation

The FIXED function allows the Data Analyst to compute an aggregation at a specified level of detail, irrespective of the dimensions present in the view. SUM only provides a total and does not account for the fixed level of detail. EXCLUDE and INCLUDE modify the level of detail but do not ensure the aggregation is independent of the view like FIXED does.