Hierarchies in Tableau

Tableau Hierarchy provides drill-down action to the report. With the help of tiny + and – symbols of Tableau Hierarchies, we can navigate from a higher level to a nested level or lower level. For this Tableau hierarchies example, we are going to use the Data Source we created in our previous article.

How to Create hierarchies in Tableau

Select and Right Click on the Dimension name, on which you want to create a hierarchy in Tableau. Please select the hierarchy option and then select create hierarchy option from the context menu

Hierarchies in Tableau 1

Once you selected the option, a new pop up window will be opened to rename it. For now, we are renaming it as Country

Add name 2

Once you click the OK button, you can see the newly created hierarchy name with the English Country Region Name member. So, Please visit Data Labels in Reports article to understand the Tableau Data Source.

Approach 1 to add a member to Hierarchies in Tableau

There are multiple ways to add members to hierarchies in tableau. The first method, Drag and drop the required dimension to the newly created hierarchy in Tableau. While dropping, it will show a horizontal line representing the member position.

For instance, if you drop the State column above the Country name, then State is at Level 1, level 2 will be Country (Country will nest inside the state), which will give a strange result. So, Please be careful while dropping the members

Add members to it 4

Once you completed, a newly dragged member will display in the Country hierarchy

Hierarchies in Tableau 5

Approach 2 to add a member to Hierarchies in Tableau

Select and Right Click on the Dimension name, which you want to add to the existing hierarchy in Tableau. Please select the hierarchy option then Add to hierarchy option and then select the name from the context menu

Hierarchies in Tableau 6

Once completed, Our dimension will add to the Country. Similarly, we added Postal code as shown below

When you add the Country name, from the below screenshot, you can notice the tiny + symbol beside the country name. This symbol will allow performing drill down action

Hierarchies in Tableau 8

When you expand the Country Region name, report will display the Sum of Sales Amount for every state present in the countries

Hierarchies in Tableau 9

When you expand the State name, report will show the Sum of Sales Amount for the current City

Hierarchies in Tableau 10

We can further drill down the report by expanding the City. When you expand the City name, report will display the Sum of Sales Amount for every postal code

Hierarchies in Tableau 11

Approach 2 to Create hierarchies in Tableau

Drag one member on to the other will automatically create hierarchies in tableau. In this example, we drag state member on to the Country name as shown below

Hierarchies in Tableau 12

when you drag state member on to the Country name, a new pop up window will be opened to rename the name as shown below. For, we are renaming it as Country

Hierarchies in Tableau 13

Once you click the OK button, you can see the newly created name with Country Name, State Province Name members. Similarly, we can add many more.

NOTE: When you add more members while dropping, it will show a horizontal line representing the member position. Please be careful while dropping the members

Remove members from Hierarchies in Tableau

Removing the Tableau Hierarchy member is very easy. To do so, select and Right Click on the member, which you want to detach or remove from it. Please select the hierarchy option and then Remove option from the context menu

Hierarchies in Tableau 15

Once you chose the option, Postal Code member will detach or remove from the Tableau hierarchy.

Hierarchies in Tableau 16

To remove members from the hierarchies, we can drag members from it to the dimension pane.

Comments are closed.