{"id":178875,"date":"2024-04-12T13:17:16","date_gmt":"2024-04-12T12:17:16","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=178875"},"modified":"2024-02-15T14:26:42","modified_gmt":"2024-02-15T13:26:42","slug":"pivottable-function","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/pivottable-function","title":{"rendered":"PivotTable function"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178875\" class=\"elementor elementor-178875\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0923345 e-flex e-con-boxed e-con\" data-id=\"0923345\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6616efd elementor-widget elementor-widget-text-editor\" data-id=\"6616efd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><strong>Excel&#8217;s PivotTable function<\/strong> is a tool of choice for Data Analysts. It brings to Microsoft&#8217;s spreadsheet software functions that are usually found in <a href=\"https:\/\/datascientest.com\/en\/acid-in-database-management\">database management systems:<\/a><\/p><ul><li>analysis<\/li><li>exploration<\/li><li>synthesis<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41822f9 elementor-widget elementor-widget-text-editor\" data-id=\"41822f9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In other words, it can be used to group data from a table and <strong>obtain statistical information on all or part of the data.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9296c34 e-flex e-con-boxed e-con\" data-id=\"9296c34\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d33d075 elementor-widget elementor-widget-heading\" data-id=\"d33d075\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">New with Excel 5<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e045f4d elementor-widget elementor-widget-text-editor\" data-id=\"e045f4d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Pivot Tables<\/strong> were introduced by Microsoft in Excel in 1993 with version Excel 5.0.<\/p><p>Before pivot tables, analysts who wanted to explore the information in a table had to use <a href=\"https:\/\/datascientest.com\/en\/how-do-i-insert-columns-and-rows-in-excel\">Excel&#8217;s standard functions and formulas<\/a> to sort and filter the data and obtain totals and averages from the samples. The process was long and rather complex.<\/p><p>It was therefore necessary to offer Excel users a simpler and more flexible method, one that didn&#8217;t require them to write formulas and filter the data.<\/p><p>The <strong>PivotTable<\/strong> function was the answer. It quickly became one of <a href=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\">Excel&#8217;s most widely used tools for data analysis.<\/a> Many management consultancies (such as<a href=\"https:\/\/www.mckinsey.com\/\"> McKinsey<\/a>, Boston Consulting Group and Bain &amp; Company) have been won over by it.<\/p><p>The same has been true of many banks and financial institutions, keen to be able to analyse data on loans, investments and other financial activities. <a href=\"https:\/\/datascientest.com\/en\/power-bi-for-retail-whats-at-stake-and-whats-the-outlook\">Retail companies have also adopted it,<\/a> as have technology companies. More generally, in any business with huge amounts of data to manage, PivotTables have been adopted, because of the ease of use of this Excel tool.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4f8f9f2 e-flex e-con-boxed e-con\" data-id=\"4f8f9f2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9d9108e elementor-widget elementor-widget-heading\" data-id=\"9d9108e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Concrete examples of application<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9200563 elementor-widget elementor-widget-text-editor\" data-id=\"9200563\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The PivotTable function can answer questions such as :<\/p><ul><li>What was the best-selling product over the past month?<\/li><li>Which sales person or territory performed best?<\/li><li>Which tasks on a project are taking longer than expected?<\/li><li>How do expenses vary from month to month?<\/li><li>Which marketing strategies are most successful?<\/li><li>What is the number of clicks generated by a given campaign?<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-072c2a1 elementor-widget elementor-widget-text-editor\" data-id=\"072c2a1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>As we can see, the PivotTable function is very powerful and can be compared to a <a href=\"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query\">function such as GROUP BY in SQL databases,<\/a> which also helps to group data together in order to obtain summary information. The difference, of course, lies in the volume of data that can be analysed, which can be much greater in an SQL database. Remember that Excel tables can hold a maximum of 1,048,576 rows, which is still a considerable amount.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-76836fc elementor-widget elementor-widget-image\" data-id=\"76836fc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/06\/marketing-digital-tableau-croise-dynamique.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab9c7db elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ab9c7db\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn how to use a pivot table<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-88548d5 e-flex e-con-boxed e-con\" data-id=\"88548d5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-265a82e elementor-widget elementor-widget-heading\" data-id=\"265a82e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What uses for pivot tables?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-027e135 elementor-widget elementor-widget-text-editor\" data-id=\"027e135\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>PivotTable<\/strong> function is particularly useful for :<\/p><ul><li><strong>Summarising vast quantities of data:<\/strong> thousands of rows can be summarised to produce a simple table that is easy to interpret.<\/li><li><strong>Statistical analysis of data:<\/strong> This function makes it easy to obtain sums, averages, counts, etc.<\/li><li><strong>Customised reports:<\/strong> The ability to organise information as you see fit can help to illustrate a report&#8217;s arguments, especially as the pivot table can be represented graphically.<\/li><li><strong>Comparing data:<\/strong> You can compare different performances from one quarter or year to the next.<\/li><li><strong>Bringing out trends:<\/strong> The summary provided by a pivot table will inevitably bring out trends that might otherwise have escaped observation.<\/li><li><strong>Filtering and sorting:<\/strong> A pivot table makes it easy to sort or filter information according to various criteria.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-99e6d42 e-flex e-con-boxed e-con\" data-id=\"99e6d42\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-67e41bc elementor-widget elementor-widget-heading\" data-id=\"67e41bc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">A few rules to follow<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec449ca elementor-widget elementor-widget-text-editor\" data-id=\"ec449ca\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Before a table can be submitted to the PivotTable function, it must comply with a <strong>certain number of principles:<\/strong><\/p><ul><li>The table must not contain any empty cells.<\/li><li>The format of a given column must be consistent for all the values in that column: dates only, numbers only, text only.<\/li><li>A header row must of course be present and filled in for each column.<\/li><li>There must be no merged cells.<\/li><li><strong>The data must be reliable and verified:<\/strong> if the original table contains incorrect information, this will inevitably find its way into the analysis.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-55fb680 e-flex e-con-boxed e-con\" data-id=\"55fb680\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dab2e8c elementor-widget elementor-widget-heading\" data-id=\"dab2e8c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Using pivot tables<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a1486e elementor-widget elementor-widget-text-editor\" data-id=\"6a1486e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>First, you need to click anywhere in the table to be analysed so that <strong>Excel can locate it.<\/strong><\/p><p>Then select <strong>PivotTable<\/strong> from the Insert menu.<\/p><p>Next, you need to indicate where you want to place the <strong>PivotTable<\/strong> &#8211; on the same sheet or on another sheet.<\/p><p>In the Design <strong>PivotTable<\/strong> window, you can tell Excel what type of summary table you want. The column headers appear and some of them need to be dragged into the &#8220;ROWS&#8221;, &#8220;COLUMNS&#8221;, &#8220;VALUES&#8221; and &#8220;FILTERS&#8221; areas.<\/p><ul><li>The &#8220;ROWS&#8221; fields appear as rows in the pivot table.<\/li><li>COLUMNS&#8221; fields appear as columns.<\/li><li>The &#8220;VALUES&#8221; fields are the data which will be summarised.<\/li><li>The &#8220;FILTER&#8221; fields are used to filter the original table.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d05291 elementor-widget elementor-widget-text-editor\" data-id=\"3d05291\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This allows you to define analyses such as: total amount per day. Note that sum is the default function, but you can choose other formulas such as average or count.<\/p><p><br \/>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Excel VBA: How to automate tasks with this language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\" target=\"_blank\" rel=\"noopener\">Excel VBA: How to automate tasks with this language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Pie Chart Excel: Mastering Data Visualization &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\" target=\"_blank\" rel=\"noopener\">Pie Chart Excel: Mastering Data Visualization <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Creating Stunning Excel Charts: A Step-by-Step Guide&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\" target=\"_blank\" rel=\"noopener\">Creating Stunning Excel Charts: A Step-by-Step Guide<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Efficient Excel Data Formatting Based on Cell Values&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\" target=\"_blank\" rel=\"noopener\">Efficient Excel Data Formatting Based on Cell Values<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;How do I insert columns and rows in Excel? &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/how-do-i-insert-columns-and-rows-in-excel\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/how-do-i-insert-columns-and-rows-in-excel\" target=\"_blank\" rel=\"noopener\">How do I insert columns and rows in Excel? <\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-208fc5e e-flex e-con-boxed e-con\" data-id=\"208fc5e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ff9ccef elementor-widget elementor-widget-heading\" data-id=\"ff9ccef\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Updating the pivot table<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-04876e7 elementor-widget elementor-widget-text-editor\" data-id=\"04876e7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><strong>Please note:<\/strong> by default, <strong>PivotTables<\/strong> are not updated when the original table is modified. You should therefore remember to update this summary table so that it reflects an up-to-date situation.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d19ae65 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d19ae65\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-analyst-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Training in data analysis<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;s PivotTable function is a tool of choice for Data Analysts. It brings to Microsoft&#8217;s spreadsheet software functions that are usually found in database management systems: analysis exploration synthesis In other words, it can be used to group data from a table and obtain statistical information on all or part of the data. New with [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":178897,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PivotTable function<\/title>\n<meta name=\"description\" content=\"If you want to use the PivotTable function, you have to take into account certain risk factors, such as the ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/pivottable-function\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PivotTable function\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;s PivotTable function is a tool of choice for Data Analysts. It brings to Microsoft&#039;s spreadsheet software functions that are usually found in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/pivottable-function\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-12T12:17:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-15T13:26:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/04\/gan.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"384\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/pivottable-function#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/pivottable-function\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"PivotTable function\",\"datePublished\":\"2024-04-12T12:17:16+00:00\",\"dateModified\":\"2024-02-15T13:26:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/pivottable-function\"},\"wordCount\":838,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/pivottable-function#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/pivottable-function\",\"url\":\"https:\/\/datascientest.com\/en\/pivottable-function\",\"name\":\"PivotTable function\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-04-12T12:17:16+00:00\",\"dateModified\":\"2024-02-15T13:26:42+00:00\",\"description\":\"If you want to use the PivotTable function, you have to take into account certain risk factors, such as the ...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/pivottable-function\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PivotTable function","description":"If you want to use the PivotTable function, you have to take into account certain risk factors, such as the ...","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:\/\/datascientest.com\/en\/pivottable-function","og_locale":"en_GB","og_type":"article","og_title":"PivotTable function","og_description":"Excel's PivotTable function is a tool of choice for Data Analysts. It brings to Microsoft's spreadsheet software functions that are usually found in","og_url":"https:\/\/datascientest.com\/en\/pivottable-function","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-04-12T12:17:16+00:00","article_modified_time":"2024-02-15T13:26:42+00:00","og_image":[{"width":768,"height":384,"url":"https:\/\/datascientest.com\/en\/files\/2024\/04\/gan.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/pivottable-function#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/pivottable-function"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"PivotTable function","datePublished":"2024-04-12T12:17:16+00:00","dateModified":"2024-02-15T13:26:42+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/pivottable-function"},"wordCount":838,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/pivottable-function#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/pivottable-function","url":"https:\/\/datascientest.com\/en\/pivottable-function","name":"PivotTable function","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-04-12T12:17:16+00:00","dateModified":"2024-02-15T13:26:42+00:00","description":"If you want to use the PivotTable function, you have to take into account certain risk factors, such as the ...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/pivottable-function"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178875"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=178875"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178875\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/178897"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=178875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=178875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=178875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}