{"id":2193,"date":"2015-12-16T23:34:00","date_gmt":"2015-12-16T22:34:00","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2193"},"modified":"2024-02-06T15:46:14","modified_gmt":"2024-02-06T14:46:14","slug":"excel-pivot-table-report-layouts","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-pivot-table-report-layouts\/","title":{"rendered":"Pivot Table Report Layouts"},"content":{"rendered":"<p><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a> have three different layouts that you can choose from: <em>Compact, Outline and Tabular Form.<\/em><\/p>\n<p>You can choose from each layout by clicking in the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> and going to\u00a0<em><strong>PivotTable Tools &gt; Design &gt; Report Layouts<\/strong><\/em><\/p>\n<p>They each have their advantages and disadvantages\u00a0and I will show you what each one of them provide below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/OtojI_EXBg8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/Report-Layouts.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/Report-Layouts.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Report-Layouts.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-pivot-table-report-layouts\/#COMPACT_LAYOUT_New_in_Excel_2010\" title=\"COMPACT LAYOUT (New in Excel 2010)\">COMPACT LAYOUT (New in Excel 2010)<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-pivot-table-report-layouts\/#OUTLINE_LAYOUT\" title=\"OUTLINE LAYOUT\">OUTLINE LAYOUT<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-pivot-table-report-layouts\/#TABULAR_LAYOUT\" title=\"TABULAR LAYOUT\">TABULAR LAYOUT<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"COMPACT_LAYOUT_New_in_Excel_2010\"><\/span><span style=\"color: #ff0000;\"><strong>COMPACT LAYOUT (New in Excel 2010)<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Advantages:<\/strong> Optimizes for readability; Keeps related data in one column<\/p>\n<p><strong>Disadvantages:<\/strong> If you\u00a0copy and paste the data into a new worksheet it will be harder to do further analysis<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/Compact-Form.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Pivot Table Report Layouts\"  class=\"alignnone size-full wp-image-2195\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/Compact-Form.png\" alt=\"Pivot Table Report Layouts\" width=\"222\" height=\"48\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/compact-pivot-table.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Pivot Table Report Layouts\"  class=\"alignnone size-full wp-image-2196\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/compact-pivot-table.png\" alt=\"Pivot Table Report Layouts\" width=\"746\" height=\"526\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/compact-pivot-table.png 746w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/compact-pivot-table-300x212.png 300w\" sizes=\"(max-width: 746px) 100vw, 746px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"OUTLINE_LAYOUT\"><\/span><span style=\"color: #ff0000;\"><strong>OUTLINE LAYOUT<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Advantages:<\/strong> Includes Field headers in each column; Can Repeat All Item Labels; Can reuse the data of the Pivot Table to a new location for further analysis; Classic Pivot Table style<\/p>\n<p><strong>Disadvantages:<\/strong> Takes too much horizontal space<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/OUTLINE.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Pivot Table Report Layouts\"  class=\"alignnone size-full wp-image-2198\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/OUTLINE.png\" alt=\"Pivot Table Report Layouts\" width=\"222\" height=\"49\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/outline-pivot-table1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Pivot Table Report Layouts\"  class=\"alignnone size-full wp-image-2201\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/outline-pivot-table1.png\" alt=\"Pivot Table Report Layouts\" width=\"864\" height=\"528\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/outline-pivot-table1.png 864w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/outline-pivot-table1-300x183.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/outline-pivot-table1-768x469.png 768w\" sizes=\"(max-width: 864px) 100vw, 864px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"TABULAR_LAYOUT\"><\/span><span style=\"color: #ff0000;\"><strong>TABULAR LAYOUT<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Advantages:<\/strong> Includes Field headers in each column; Can Repeat All Item Labels; See all data in a traditional table format used in Pivot Tables since their invention; Can reuse the data of the Pivot Table to a new location for further analysis<\/p>\n<p><strong>Disadvantages:<\/strong>\u00a0Takes too much horizontal space; Subtotals can never appear at the top of the group<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/tabular.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Pivot Table Report Layouts\"  class=\"alignnone size-full wp-image-2203\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/tabular.png\" alt=\"Pivot Table Report Layouts\" width=\"221\" height=\"47\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/tabular-pivot.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Pivot Table Report Layouts\"  class=\"alignnone size-full wp-image-2204\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/tabular-pivot.png\" alt=\"Pivot Table Report Layouts\" width=\"860\" height=\"482\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/tabular-pivot.png 860w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/tabular-pivot-300x168.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/tabular-pivot-768x430.png 768w\" sizes=\"(max-width: 860px) 100vw, 860px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff; text-decoration: underline;\">HELPFUL RESOURCE:<\/span><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/003-xtreme-pivot-table-online-excel-course\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Pivot Table Report Layouts\"  class=\"alignnone wp-image-2211 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/Xtreme-Pivot-TAble-Course.png\" alt=\"Pivot Table Report Layouts\" width=\"686\" height=\"78\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/Xtreme-Pivot-TAble-Course.png 686w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/12\/Xtreme-Pivot-TAble-Course-300x34.png 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot Tables have three different layouts that you can choose from: Compact, Outline and Tabular Form. You can choose from each layout by clicking in the Pivot Table and going to\u00a0PivotTable Tools &gt; Design &gt; Report Layouts They each have their advantages and disadvantages\u00a0and I will show you what each one of them provide below: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17494,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[17,4],"tags":[86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2193"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=2193"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2193\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17494"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}