{"id":10628,"date":"2018-03-13T10:19:07","date_gmt":"2018-03-13T10:19:07","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=10628"},"modified":"2025-03-01T14:43:28","modified_gmt":"2025-03-01T09:13:28","slug":"tableau-hierarchy","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/","title":{"rendered":"Hierarchies in Tableau – A step by step guide to create Tableau hierarchy"},"content":{"rendered":"

In this tutorial, we are going to learn how to create hierarchies in Tableau. Hierarchies play a very important role in using the data fields in an organized manner. So, let us learn in a stepwise manner how to create and use hierarchies from your data set in Tableau.<\/p>\n

What are Hierarchies in Tableau?<\/h3>\n

Before we start learning how to create hierarchies in Tableau, let us have a better understanding of hierarchies. The term hierarchy is not specific to Tableau and you might have heard and used it in many places before.<\/p>\n

In the context of data, hierarchies are a logical arrangement of relevant unique attributes in a data set. Hierarchies arrange data fields in a level, for instance, a Geography hierarchy would have a region, country, state, city, area levels. Or, a Time hierarchy has a year, month, week, day as its levels.<\/p>\n

By creating hierarchies in Tableau, we set our data on different levels of detail and organize it. Tableau can automatically create hierarchies by detecting relevant fields or you can create custom hierarchies.<\/p>\n

Before moving ahead, have a quick revision of reporting in Tableau<\/a>.<\/strong><\/em><\/p>\n

Creating Hierarchies in Tableau<\/h3>\n

Follow the steps given below to create hierarchies in Tableau.<\/p>\n

Step 1: Drag a Field in Tableau Hierarchy<\/h4>\n

To start with creating a hierarchy in your data set, select a field from the list of dimensions and measures. Select and hold the field and drag it on to or on top of another field. By doing this, we add a field at a sub-level in the hierarchy.<\/p>\n

Another way of adding a field in an existing hierarchy is to right-click on a field name, then select Hierarchy<\/strong> from the list. Then select Add to hierarchy option<\/strong> and select the name of the hierarchy in which you wish to add the field.\"drag<\/a><\/p>\n

Step 2: Name the Hierarchies in Tableau<\/h4>\n

As soon as you add a field on the top of another field, a window pops up where you need to enter the name of the hierarchy. Enter a suitable name for the hierarchy and click on OK<\/strong>.\"name<\/a><\/p>\n

Step 3: Add More Fields in Tableau Hierarchy<\/h4>\n

Once you enter a name, your hierarchy can be seen on the left Data panel<\/strong> as shown in the screenshot below. We put the Sub-category<\/em> field under the Category field<\/em>. That is, Category<\/em> is on the first level of the hierarchy and Sub-category<\/em> is on the second level. Following step 1, you can add more fields under a field in a hierarchy.\"add<\/a><\/p>\n

Step 4: Drill Down Hierarchy in Tableau<\/h4>\n

Now, you can use this hierarchy into visualization by putting it in a Rows<\/strong> or Columns<\/strong> section. To drill down in a hierarchy, click on the plus + sign<\/strong> given right next to a field name. As you can see in the screenshot below, our field Category<\/em> is on the top of the hierarchy. When we click on the + sign near the field name, the field on a lower level in the hierarchy will be shown.\"drill-down<\/a><\/p>\n

Step 5: Analyze Data in Tableau Hierarchy<\/h4>\n

As shown in the screenshot below, the field Sub-category<\/strong> and its contents are also visible in the bar chart<\/strong><\/em><\/a> now. This is after drilling-down the hierarchy by one level. To go back to the top or a preceding field in the hierarchy, click on the minus – sign<\/strong> present near a field name. In this way, you can easily drill up or down a hierarchy to see and analyze data at different levels of detail.\"subcategory<\/a><\/p>\n

Step 6: Geo Hierarchy in Tableau<\/h4>\n

The screenshot below shows a geo hierarchy<\/strong> where hierarchy with the name Geography<\/strong> is created. Under it, there are fields at sub-level such as Region, Country, State, City,<\/em> etc.\"geo<\/a><\/p>\n

How to Remove a Hierarchy in Tableau?<\/h3>\n

To remove a hierarchy in Tableau<\/a> all you need to do is right-click on the hierarchy name (present in the Data pane<\/strong>) and select the option Remove Hierarchy<\/strong>. This will remove all the fields from that hierarchy and its name will no longer show in the Data pane<\/strong>.<\/p>\n

Summary<\/h3>\n

Finally, we learnt everything about Hierarchies in Tableau<\/em>. We hope you were able to understand the concept behind hierarchies and how to create them in Tableau.<\/p>\n

Now!! Learn how to create Trend Lines in Tableau<\/a> with DataFlair.<\/strong><\/em><\/p>\n

Still if you have any queries, feel free to ask in the comment section. Our team will help you.<\/p>\n

Happy Learning\ud83d\ude03

In this tutorial, we are going to learn how to create hierarchies in Tableau. Hierarchies play a very important role in using the data fields in an organized manner. So, let us learn in...<\/p>\n","protected":false},"author":5,"featured_media":75715,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[3139,5637,21839,14297,15749],"class_list":["post-10628","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-creating-hierarchies-in-tableau","tag-hierarchies-in-tableau","tag-how-to-remove-a-hierarchy-in-tableau","tag-tableau-hierarchy","tag-what-is-hierarchy-in-tableau"],"yoast_head":"\nHierarchies in Tableau - A step by step guide to create Tableau hierarchy - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn about hierarchies in Tableau, how to create them step by step with the help of examples. Also, learn to remove a hierarchy in Tableau.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hierarchies in Tableau - A step by step guide to create Tableau hierarchy - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn about hierarchies in Tableau, how to create them step by step with the help of examples. Also, learn to remove a hierarchy in Tableau.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-13T10:19:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T09:13:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/how-to-create-hierarchies-in-tableau.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hierarchies in Tableau - A step by step guide to create Tableau hierarchy - DataFlair","description":"Learn about hierarchies in Tableau, how to create them step by step with the help of examples. Also, learn to remove a hierarchy in Tableau.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/","og_locale":"en_US","og_type":"article","og_title":"Hierarchies in Tableau - A step by step guide to create Tableau hierarchy - DataFlair","og_description":"Learn about hierarchies in Tableau, how to create them step by step with the help of examples. Also, learn to remove a hierarchy in Tableau.","og_url":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-13T10:19:07+00:00","article_modified_time":"2025-03-01T09:13:28+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/how-to-create-hierarchies-in-tableau.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Hierarchies in Tableau – A step by step guide to create Tableau hierarchy","datePublished":"2018-03-13T10:19:07+00:00","dateModified":"2025-03-01T09:13:28+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/"},"wordCount":736,"commentCount":4,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/how-to-create-hierarchies-in-tableau.jpg","keywords":["Creating Hierarchies in Tableau","Hierarchies in Tableau","How to Remove a Hierarchy in Tableau?","Tableau Hierarchy","What is Hierarchy in Tableau"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/","url":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/","name":"Hierarchies in Tableau - A step by step guide to create Tableau hierarchy - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/how-to-create-hierarchies-in-tableau.jpg","datePublished":"2018-03-13T10:19:07+00:00","dateModified":"2025-03-01T09:13:28+00:00","description":"Learn about hierarchies in Tableau, how to create them step by step with the help of examples. Also, learn to remove a hierarchy in Tableau.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/how-to-create-hierarchies-in-tableau.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/how-to-create-hierarchies-in-tableau.jpg","width":802,"height":420,"caption":"Tableau hierarchies"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-hierarchy\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Hierarchies in Tableau – A step by step guide to create Tableau hierarchy"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=10628"}],"version-history":[{"count":8,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10628\/revisions"}],"predecessor-version":[{"id":144358,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10628\/revisions\/144358"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/75715"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=10628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=10628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=10628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}