Tableau Desktop Specialist — Question 133

A Data Analyst needs to calculate the percent of regional sales that each state contributes to. As a first step, the analyst needs to calculate total sales per region.

Which calculation should the analyst use to do this?

Answer options

• A. {FIXED (State): SUM([Sales])
• B. {FIXED [Region]: TOTAL([Sales])}
• C. {FIXED [State], [Region]: SUM([Sales])}
• D. {FIXED [Region]: SUM{[Sales])}

Correct answer: D

Explanation

The correct answer is D because it accurately uses the FIXED expression to calculate the total sales for each region by summing the sales values. Options A and C incorrectly fix the calculation at the state level, which does not provide the required total per region. Option B uses TOTAL, which is not appropriate for this calculation.