Tableau Desktop Specialist · Free Practice Question Medium
Question 14
Using a dataset with "Country", "State", "City", "Sales", and "Profit" in Tableau Desktop, you create a hierarchy named "Geo" with "Country" at the top, but dragging it to Columns shows "City" first when drilling down. Which step correctly adjusts the hierarchy to drill from "Country" to "State" to "City"?
-
A
Go to "Data" > "[Data Source]" > "Adjust Hierarchy," reorder "Country," "State," "City," and apply the changes.
-
B
Drag "State" to the Columns shelf before "Country," right-click "Country," and select "Reorder Hierarchy" to prioritize "State."
-
C
Right-click "Country" in the Data pane, select "Hierarchy" > "Create Hierarchy," name it "Geo," drag "State" below "Country," then "City" below "State," and click "OK."
-
D
Right-click the "Geo" hierarchy in the Data pane, select "Edit Hierarchy," and move "State" between "Country" and "City" in the dialog.
Reveal correct answer
Correct answer: C
A.
"Adjust Hierarchy" isn’t a menu - hierarchy is a Data pane only option.(https://help.tableau.com/current/pro/desktop/en-us/datasource_tab.htm)
B.
Columns shelf adjusts view, not hierarchy. Also, "Reorder Hierarchy" doesn’t exist.
C.
Right-click "Country" > "Hierarchy" > "Create Hierarchy", drag "State" and "City" in order (https://help.tableau.com/current/pro/desktop/en-us/hierarchies.htm).
Result: Drill-down follows Country > State > City.
D.
No "Edit Hierarchy" option - you can reorder by dragging fields in hierarchy. Subtle trap.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
