{"id":11846,"date":"2018-03-27T06:48:38","date_gmt":"2018-03-27T06:48:38","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=11846"},"modified":"2025-03-01T21:30:35","modified_gmt":"2025-03-01T16:00:35","slug":"pivot-in-tableau","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/","title":{"rendered":"Pivot in Tableau – How to Create Tableau Pivot"},"content":{"rendered":"

In our\u00a0last tutorial, we study How to Create Hexabin Chart in Tableau<\/strong><\/a>. Here, in this article, we\u00a0introduce Pivot in Tableau and uses of Tableau Pivot. It also demonstrates how to create a table calculation using the calculation editor. Moreover, we will discuss an example of Pivot in Tableau.<\/p>\n

So, let’s start.<\/p>\n

Tableau Pivot<\/h3>\n

To explain pivot in tableau let\u2019s take facilitate of associate degree example:
\nSuppose we’ve conducted a survey of the popularity\/ preference of laundry machines and therefore the result’s the surpass.
\nBelow:<\/p>\n

\"Pivot<\/a><\/p>\n

So, currently, the necessity is that we would like to research the feedback of every washer on the idea of agree, disagree and neutral in Tableau.<\/p>\n

Let\u2019s connect Tableau to the surpass and move ahead with the visualization:<\/p>\n

\"Pivot<\/a>

Connecting Tableau to the Surpass<\/p><\/div>\n

The on top of visualization isn’t satisfying the necessity because the visualization is showing the entire variety of a specific combination ( i.e the highlighted Tableau visualization is showing that their area unit five records wherever we have a Neutral agree on feedback). This can be undoubtedly not what we would like.<\/p>\n

How to Create Pivot in Tableau?<\/h3>\n

These are the following steps to create Pivot:<\/p>\n

Step -1<\/strong><\/p>\n

After you’ve got established you knowledge supply association and have got the preview of the data; click on Manage data pill to induce the below visualization:<\/p>\n

\"Pivot<\/a><\/p>\n

Step-2<\/strong><\/p>\n

Pivot the table as below:<\/p>\n

\"Pivot<\/a><\/p>\n

Step-3<\/strong>
\nThe pivot result are like this:<\/p>\n

\"Pivot<\/a><\/p>\n

The original fields within the knowledge supply square measure replaced with new fields referred to as \u201cPivot field names\u201d and \u201cPivot field values.\u201d you’ll be able to invariably\u00a0rename the new pivot fields.<\/p>\n

Step-4<\/strong><\/p>\n

Finally, the Tableau visualisation which can state the individual feedback of the laundry Machines:<\/p>\n

\"Pivot<\/a><\/p>\n

Few points to recollect whereas operating with Pivot:<\/p>\n

Operating with Pivots in Tableau<\/h3>\n
    \n
  • Tableau Pivot possibility is offered from the grid and data grid.<\/li>\n
  • All fields within the pivot should be from an identical association.<\/li>\n
  • Only one pivot is allowed per knowledge supply.<\/li>\n
  • Pivot fields are often used because the be a part of a key.<\/li>\n<\/ul>\n

    Conclusion<\/h3>\n

    In this tutorial, we learned about What is Pivot in Tableau, how to create it and its working. Furthermore, if you have any query, free feel to ask in a comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In our\u00a0last tutorial, we study How to Create Hexabin Chart in Tableau. Here, in this article, we\u00a0introduce Pivot in Tableau and uses of Tableau Pivot. It also demonstrates how to create a table calculation...<\/p>\n","protected":false},"author":5,"featured_media":11866,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[3076,3095,3147,9274,9529,14374],"class_list":["post-11846","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-create-pivot-in-tableau","tag-create-tableau-pivot","tag-creating-pivot-in-tableau","tag-operating-with-pivots-in-tableau","tag-pivot-in-tableau","tag-tableau-pivot"],"yoast_head":"\nPivot in Tableau - How to Create Tableau Pivot - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn What is Tableau Pivot with example and working. See how to create Pivot in Tableau in easy step by step manner..\" \/>\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\/pivot-in-tableau\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot in Tableau - How to Create Tableau Pivot - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn What is Tableau Pivot with example and working. See how to create Pivot in Tableau in easy step by step manner..\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/\" \/>\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-27T06:48:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T16:00:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Pivot-in-Tableau-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\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=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pivot in Tableau - How to Create Tableau Pivot - DataFlair","description":"Learn What is Tableau Pivot with example and working. See how to create Pivot in Tableau in easy step by step manner..","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\/pivot-in-tableau\/","og_locale":"en_US","og_type":"article","og_title":"Pivot in Tableau - How to Create Tableau Pivot - DataFlair","og_description":"Learn What is Tableau Pivot with example and working. See how to create Pivot in Tableau in easy step by step manner..","og_url":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-27T06:48:38+00:00","article_modified_time":"2025-03-01T16:00:35+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Pivot-in-Tableau-01.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Pivot in Tableau – How to Create Tableau Pivot","datePublished":"2018-03-27T06:48:38+00:00","dateModified":"2025-03-01T16:00:35+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/"},"wordCount":397,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Pivot-in-Tableau-01.jpg","keywords":["Create Pivot in Tableau","Create Tableau Pivot","Creating Pivot in Tableau","Operating with Pivots in Tableau","pivot in Tableau","Tableau pivot"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/","url":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/","name":"Pivot in Tableau - How to Create Tableau Pivot - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Pivot-in-Tableau-01.jpg","datePublished":"2018-03-27T06:48:38+00:00","dateModified":"2025-03-01T16:00:35+00:00","description":"Learn What is Tableau Pivot with example and working. See how to create Pivot in Tableau in easy step by step manner..","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Pivot-in-Tableau-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Pivot-in-Tableau-01.jpg","width":1200,"height":628,"caption":"What is Pivot in Tableau"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/pivot-in-tableau\/#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":"Pivot in Tableau – How to Create Tableau Pivot"}]},{"@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\/11846","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=11846"}],"version-history":[{"count":7,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11846\/revisions"}],"predecessor-version":[{"id":144420,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11846\/revisions\/144420"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/11866"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=11846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=11846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=11846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}