{"id":9718,"date":"2018-03-01T11:03:34","date_gmt":"2018-03-01T11:03:34","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=9718"},"modified":"2025-03-06T20:34:13","modified_gmt":"2025-03-06T15:04:13","slug":"tableau-text-table","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/","title":{"rendered":"Tableau Text Table | Tableau Crosstab"},"content":{"rendered":"<p>In this <a href=\"https:\/\/data-flair.training\/blogs\/tableau-navigation\/\"><strong>Tableau\u00a0tutorial<\/strong><\/a>, we are going to study what is Tableau Text Table or Tableau Crosstab, various steps to create text table in tableau them and how we can use Crosstab in Tableau.<\/p>\n<h3>Tableau Text Table<\/h3>\n<p>Tableau text table or Tableau Crosstab, a shortened term for cross tabulation. Another common term that can be used to describe text tables is a spreadsheet. A text table is a series of rows and columns that have headers and numeric values. Tableau Text table is great when the audience requires seeing the individual values.<\/p>\n<p>A limitation of tableau crosstab is that it requires attentive processing\u2014whoever is using the text table needs to focus on reading and comparing the numbers because any patterns or insights are not very easy to spot.<\/p>\n<p>Follow this link to know about <a href=\"https:\/\/data-flair.training\/blogs\/tableau-design-flow\/\"><strong>Tableau Design Flow<\/strong><\/a> &amp; <a href=\"https:\/\/data-flair.training\/blogs\/tableau-file-types\/\"><strong>Tableau FIle Type<\/strong><\/a> in detail.<\/p>\n<p>In this recipe, we will create a Tableau text table that shows the top 20 movies from 2007-2011, based on the worldwide gross amount.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-135.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9734 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-135.png\" alt=\"Tableau Text table - Tableau Crosstab\" width=\"886\" height=\"524\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-135.png 886w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-135-150x89.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-135-300x177.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-135-768x454.png 768w\" sizes=\"auto, (max-width: 886px) 100vw, 886px\" \/><\/a><\/p>\n<h3>How to Create Text Table in Tableau<\/h3>\n<p>i. Change the default number format of Audience score %. You can do this by right-clicking the field Audience score % in the Measures section of the sidebar, selecting Default properties and then Number Format\u2026. In the window that shows up, set the following:<\/p>\n<ul>\n<li>Number (Custom)<\/li>\n<li>Decimal places: <strong>0<\/strong><\/li>\n<li>Suffix %<\/li>\n<\/ul>\n<p>ii. From Dimensions, drag Film to Rows.<\/p>\n<p>iii. Now from Dimensions, drag Year to Rows.<\/p>\n<p>Let&#8217;s revise\u00a0<a href=\"https:\/\/data-flair.training\/blogs\/adding-worksheets-renaming-worksheet\/\"><strong>Adding Worksheets And Renaming Worksheet In Tableau<\/strong><\/a> in detail.<\/p>\n<p>iv. From Dimensions, drag Film to Filters. This will open a window with several options for filtering the Film<\/p>\n<p>v. Select the Top Choose By field: and specify Top 20 by Average Rotten Tomatoes %, as shown here:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-136.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9735 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-136.png\" alt=\"Tableau Text table\" width=\"702\" height=\"382\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-136.png 702w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-136-150x82.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-136-300x163.png 300w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/a><\/p>\n<p>vi. From Measures, drag Worldwide Gross Amount to Text in the Marks<\/p>\n<p>vii. Right-click on the Worldwide Gross Amount pill in the Marks card, and choose Format.<\/p>\n<p>viii. Format the Pane tab to use:<\/p>\n<ul>\n<li>Currency (Custom)<\/li>\n<li>Decimal places: <strong>0<\/strong><\/li>\n<li>Prefix: <strong>$<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-137.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9736 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-137.png\" alt=\"Tableau Text table\" width=\"627\" height=\"516\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-137.png 627w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-137-150x123.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-137-300x247.png 300w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>ix. Double-click on Audience score % in the Measures This adds this measure to the text table. This also introduces a new Measure Values shelf in your canvas.<\/p>\n<p>x. From Measures, double-click on Rotten Tomatoes % to add this to the text table.<\/p>\n<p>xi. Change the Rotten Tomatoes % aggregation to Average. You can do this by right-clicking on this pill in the Measure Values shelf, going to Measure (Sum), and changing this to Average.<\/p>\n<p>Read about <a href=\"https:\/\/data-flair.training\/blogs\/tableau-heat-map\/\"><strong>Tableau\u00a0<\/strong><strong>Heat Map<\/strong><\/a> &amp;\u00a0<strong><a href=\"https:\/\/data-flair.training\/blogs\/tableau-data-quality-problems\/\">Dealing With Data Quality Problems In Tableau<\/a>\u00a0<\/strong>in detail.<\/p>\n<p>xii. From Measures, double-click on Audience Score % to add this to the text table.<\/p>\n<p>xiii. Change the aggregation of Audience Score % to Average.<\/p>\n<p>xiv. From Measures, double-click on Profitability to add this to the text table.<\/p>\n<p>xv. Rearrange the pills in the Measure Values shelf by dragging them manually to have the following order:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-138.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9737 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-138.png\" alt=\"Tableau Text table\" width=\"316\" height=\"229\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-138.png 316w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-138-150x109.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Screenshot-138-300x217.png 300w\" sizes=\"auto, (max-width: 316px) 100vw, 316px\" \/><\/a><\/p>\n<p>xvi. Right-click the Film pill in Rows, and click on Sort\u2026.<br \/>\nxvii. In the Sort window, select:<\/p>\n<ul>\n<li>Sort order Descending<\/li>\n<li>Sort by field Worldwide Gross Amount using Aggregation of Sum<\/li>\n<\/ul>\n<h3>Conclusion<\/h3>\n<p>In conclusion, we learned about what Tableau Crosstab, consequently how to create Crosstab in Tableau, and also how to use tableau text table our software. Furthermore, if you have any query, feel free to ask in a comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this Tableau\u00a0tutorial, we are going to study what is Tableau Text Table or Tableau Crosstab, various steps to create text table in tableau them and how we can use Crosstab in Tableau. Tableau&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":9733,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[2190,2196,3098,4054,4058,14205,14447],"class_list":["post-9718","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-build-crosstab-in-tableau","tag-build-text-table-in-tableau","tag-create-text-table-in-tableau","tag-draw-crosstab-in-tableau","tag-draw-text-table-in-tableau","tag-tableau-crosstab","tag-tableau-text-table"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tableau Text Table | Tableau Crosstab - DataFlair<\/title>\n<meta name=\"description\" content=\"Tableau Text Table-what is Tableau Crosstab, steps to create text table in tableau, how to build Crosstab in tableau with example\" \/>\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-text-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tableau Text Table | Tableau Crosstab - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Tableau Text Table-what is Tableau Crosstab, steps to create text table in tableau, how to build Crosstab in tableau with example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-text-table\/\" \/>\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-01T11:03:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-06T15:04:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Text-table-crosstab-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":"Tableau Text Table | Tableau Crosstab - DataFlair","description":"Tableau Text Table-what is Tableau Crosstab, steps to create text table in tableau, how to build Crosstab in tableau with example","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-text-table\/","og_locale":"en_US","og_type":"article","og_title":"Tableau Text Table | Tableau Crosstab - DataFlair","og_description":"Tableau Text Table-what is Tableau Crosstab, steps to create text table in tableau, how to build Crosstab in tableau with example","og_url":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-01T11:03:34+00:00","article_modified_time":"2025-03-06T15:04:13+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Text-table-crosstab-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\/tableau-text-table\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Tableau Text Table | Tableau Crosstab","datePublished":"2018-03-01T11:03:34+00:00","dateModified":"2025-03-06T15:04:13+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/"},"wordCount":539,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Text-table-crosstab-01.jpg","keywords":["Build CrossTab in Tableau","Build Text Table in Tableau","Create Text Table in Tableau","Draw CrossTab in Tableau","Draw Text Table in Tableau","Tableau CrossTab","Tableau Text Table"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-text-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/","url":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/","name":"Tableau Text Table | Tableau Crosstab - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Text-table-crosstab-01.jpg","datePublished":"2018-03-01T11:03:34+00:00","dateModified":"2025-03-06T15:04:13+00:00","description":"Tableau Text Table-what is Tableau Crosstab, steps to create text table in tableau, how to build Crosstab in tableau with example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-text-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Text-table-crosstab-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Text-table-crosstab-01.jpg","width":1200,"height":628,"caption":"Tableau Text table - Tableau Crosstab"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-text-table\/#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":"Tableau Text Table | Tableau Crosstab"}]},{"@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\/9718","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=9718"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/9718\/revisions"}],"predecessor-version":[{"id":144507,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/9718\/revisions\/144507"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/9733"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=9718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=9718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=9718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}