{"id":23888,"date":"2021-12-08T08:00:14","date_gmt":"2021-12-08T07:00:14","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23888"},"modified":"2024-02-06T15:49:56","modified_gmt":"2024-02-06T14:49:56","slug":"create-multiple-subtotals-in-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-multiple-subtotals-in-pivot-table\/","title":{"rendered":"Create Multiple Subtotals in Excel Pivot Tables"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Create-multiple-subtotals.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create Multiple Subtotals in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25369\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Create-multiple-subtotals.png\" alt=\"Create Multiple Subtotals in Excel Pivot Tables\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Create-multiple-subtotals.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Create-multiple-subtotals-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Create-multiple-subtotals-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>With <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> Subtotals, we become accustomed to getting the sum as this is the default function used. Did you know that you can <strong>create multiple subtotals and use different functions<\/strong>?<\/p>\n<p>This is the full list of the subtotal functions:<\/p>\n<ul>\n<li>Sum<\/li>\n<li>Count<\/li>\n<li>Average<\/li>\n<li>Max<\/li>\n<li>Min<\/li>\n<li>Product<\/li>\n<li>Count Numbers<\/li>\n<li>StdDev<\/li>\n<li>StdDevp<\/li>\n<li>Var<\/li>\n<li>Varp<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><em><strong>Exercise Workbook:<\/strong><\/em><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals.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\">Create-multiple-subtotals.xlsx<\/span><\/a><\/strong><\/p>\n<p class=\"line-two\">\n<\/div>\n<hr \/>\n<p>Let us now have some fun with multiple subtotals!<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> This is our Pivot Table. Click on the arrow beside\u00a0<strong>Products<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel Pivot Table on two pages\"  class=\"alignnone size-full wp-image-23900\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-01.jpg\" alt=\"Print Excel Pivot Table on two pages\" width=\"912\" height=\"546\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-01.jpg 912w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-01-300x180.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-01-768x460.jpg 768w\" sizes=\"(max-width: 912px) 100vw, 912px\" \/><\/p>\n<p>Select\u00a0<strong>Field Settings<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel Pivot Table on two pages\"  class=\"alignnone size-full wp-image-23901\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-02.jpg\" alt=\"Print Excel Pivot Table on two pages\" width=\"261\" height=\"537\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-02.jpg 261w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-02-146x300.jpg 146w\" sizes=\"(max-width: 261px) 100vw, 261px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Select\u00a0<strong>Custom<\/strong> for the Subtotals option. And you can select\u00a0<strong>Sum, Count, Average, Max, Min<\/strong> to see what happens!<\/p>\n<p>Click\u00a0<strong>OK<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel Pivot Table on two pages\"  class=\"alignnone size-full wp-image-23902\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-03.jpg\" alt=\"Print Excel Pivot Table on two pages\" width=\"420\" height=\"412\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-03.jpg 420w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-03-300x294.jpg 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/p>\n<p>Now you have the different subtotals for each <strong>Product<\/strong>! You can see that for <strong>Bottles and Ice Cubes<\/strong>, the <strong>sum, count, average, max and min<\/strong> are all being shown!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Print Excel Pivot Table on two pages\"  class=\"alignnone wp-image-23903 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-04.jpg\" alt=\"Print Excel Pivot Table on two pages\" width=\"622\" height=\"524\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-04.jpg 622w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Create-multiple-subtotals-04-300x253.jpg 300w\" sizes=\"(max-width: 622px) 100vw, 622px\" \/><\/p>\n<p>By following the same steps, you can add or remove other functions including product, count numbers, StdDev, StdDevp, Var and\/or Varp!<\/p>\n<p>&nbsp;<\/p>\n<p>To <strong>remove these subtotals<\/strong>, follow the steps below:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span><strong>Right-click on the row label<\/strong> you want to remove.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create Multiple Subtotals in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25347\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-1.png\" alt=\"Create Multiple Subtotals in Excel Pivot Tables\" width=\"575\" height=\"499\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-1.png 575w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-1-300x260.png 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span><strong>Click on subtotal<\/strong> to remove the check mark.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create Multiple Subtotals in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25348\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-2.png\" alt=\"Create Multiple Subtotals in Excel Pivot Tables\" width=\"556\" height=\"479\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-2.png 556w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-2-300x258.png 300w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/a><\/p>\n<p>The subtotals will be removed!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create Multiple Subtotals in Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25349\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-3.png\" alt=\"Create Multiple Subtotals in Excel Pivot Tables\" width=\"578\" height=\"533\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-3.png 578w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/11\/Report-Filter-Layout-3-300x277.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/a><\/p>\n<p>The subtotals of the field selected will be removed! You can also add multiple grand totals to your Pivot Table, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-multiple-grand-totals\/\" target=\"_blank\"><strong>Click here<\/strong><\/a> to learn how!<\/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>With Pivot Table Subtotals, we become accustomed to getting the sum as this is the default function used. Did you know that you can create multiple subtotals and use different functions? This is the full list of the subtotal functions: Sum Count Average Max Min Product Count Numbers StdDev StdDevp Var Varp &nbsp; Exercise Workbook: [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":25369,"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":[864,865,867,866],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23888"}],"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=23888"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23888\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25369"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}