{"id":24083,"date":"2021-12-20T06:21:09","date_gmt":"2021-12-20T05:21:09","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24083"},"modified":"2024-02-06T15:50:10","modified_gmt":"2024-02-06T14:50:10","slug":"field-list-areas","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/field-list-areas\/","title":{"rendered":"Field List &#038; Areas"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Field-List-Areas.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25359\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Field-List-Areas.png\" alt=\"Field List &amp; Areas\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Field-List-Areas.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Field-List-Areas-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Field-List-Areas-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\"><\/a><\/p>\n<p>When working with <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>, one of the most crucial concepts is understanding how the Field List and its different Areas work. Being able to utilize this correctly will spell the difference on how effective you can perform your analysis with Pivot Tables!<\/p>\n<p>Let us go over the different sections:<\/p>\n<ul>\n<li>Fields<\/li>\n<li>Rows<\/li>\n<li>Columns<\/li>\n<li>Values<\/li>\n<li>Report Filter<\/li>\n<\/ul>\n<p><em><strong>Exercise Workbook:<\/strong><\/em><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Field-List-Areas.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<hr \/>\n<p>Here is our initial data table:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24227\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-00.jpg\" alt=\"Field List &amp; Areas\" width=\"1028\" height=\"508\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-00.jpg 1028w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-00-300x148.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-00-1024x506.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-00-768x380.jpg 768w\" sizes=\"(max-width: 1028px) 100vw, 1028px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Now the first part is the\u00a0<strong>Fields <\/strong>section, which represents the column headings of our data source:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone wp-image-24228 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-01.jpg\" alt=\"Field List &amp; Areas\" width=\"332\" height=\"661\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-01.jpg 332w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-01-151x300.jpg 151w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> The <strong>Row<\/strong> labels show the unique fields on the left-hand side of our <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>. Drag <strong>PRODUCTS<\/strong> to\u00a0<strong>Rows<\/strong> to see how this looks like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24229\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-02.jpg\" alt=\"Field List &amp; Areas\" width=\"332\" height=\"661\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-02.jpg 332w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-02-151x300.jpg 151w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/p>\n<p>Now you can see our Products are listed on the Pivot Table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24230\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-03.jpg\" alt=\"Field List &amp; Areas\" width=\"624\" height=\"689\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-03.jpg 624w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-03-272x300.jpg 272w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> The\u00a0<strong>Column\u00a0<\/strong>labels show the trend of your data. For example, this could be periods, trends, time, month, years.<\/p>\n<p>Let us drag the\u00a0<strong>SALES YEAR\u00a0<\/strong>to the\u00a0<strong>Columns<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24231\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-04.jpg\" alt=\"Field List &amp; Areas\" width=\"332\" height=\"661\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-04.jpg 332w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-04-151x300.jpg 151w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/p>\n<p>Now you can see the years 2012 &#8211; 2014 as the columns.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24232\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-05.jpg\" alt=\"Field List &amp; Areas\" width=\"766\" height=\"657\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-05.jpg 766w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-05-300x257.jpg 300w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span>\u00a0<strong>Values\u00a0<\/strong>are fields that you want to calculate or quantify. Examples are sum (for sales), count (for number of units), average (for prices), and maximum\/minimum (for values).<\/p>\n<p>Let us drag\u00a0<strong>SALES\u00a0<\/strong>to\u00a0<strong>Values<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24233\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-06.jpg\" alt=\"Field List &amp; Areas\" width=\"332\" height=\"661\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-06.jpg 332w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-06-151x300.jpg 151w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/p>\n<p>You will get the <strong>Sum of Sales<\/strong> values here for each Product-Year combination.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24234\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-07.jpg\" alt=\"Field List &amp; Areas\" width=\"829\" height=\"658\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-07.jpg 829w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-07-300x238.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-07-768x610.jpg 768w\" sizes=\"(max-width: 829px) 100vw, 829px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> The last one is our\u00a0<strong>Report Filters<\/strong>. These are optional fields that you want to drill down on. Examples are regions, periods, business units, or staff.<\/p>\n<p>Drag both\u00a0<strong>SALES REGION<\/strong> and\u00a0<strong>SALES PERSON<\/strong> to the <strong>Filters\u00a0<\/strong>area<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24235\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-08.jpg\" alt=\"Field List &amp; Areas\" width=\"332\" height=\"661\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-08.jpg 332w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-08-151x300.jpg 151w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/p>\n<p>Click on any filter and you will be able to filter your Pivot Table data according to your selection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Field List &amp; Areas\"  class=\"alignnone size-full wp-image-24236\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-09.jpg\" alt=\"Field List &amp; Areas\" width=\"882\" height=\"682\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-09.jpg 882w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-09-300x232.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Field-List-Areas-09-768x594.jpg 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When working with Pivot Tables, one of the most crucial concepts is understanding how the Field List and its different Areas work. Being able to utilize this correctly will spell the difference on how effective you can perform your analysis with Pivot Tables! Let us go over the different sections: Fields Rows Columns Values Report [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":25359,"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":[4],"tags":[268,855,854],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24083"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=24083"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24083\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25359"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}