{"id":2027,"date":"2015-11-26T18:36:24","date_gmt":"2015-11-26T17:36:24","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2027"},"modified":"2024-02-06T15:45:59","modified_gmt":"2024-02-06T14:45:59","slug":"insert-subtotals-to-an-excel-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-subtotals-to-an-excel-pivot-table\/","title":{"rendered":"Insert Subtotals to a Pivot Table"},"content":{"rendered":"<p>When you create a <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> that has multiple fields in the Row Labels, Excel will automatically add a Subtotal to the top of the Group.<\/p>\n<p>What about if you want to change the Subtotals to show at the bottom of the Group or take the Subtotals out all together?<\/p>\n<p>Well you have that flexibility when you are dealing with Subtotals, here is how:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/7WzQS3uGm_I?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\/11\/Insert-Subtotals.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Insert-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\">Insert-Subtotals.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Enter at least <strong>two Fields in the Row Labels<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/ROW-LABELS.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Subtotals to a Pivot Table\"  class=\"alignnone wp-image-2037 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/ROW-LABELS.png\" alt=\"Insert Subtotals to a Pivot Table\" width=\"122\" height=\"161\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Click in your Pivot Table and go to <em><strong>PivotTable Tools &gt; Design &gt; Subtotals<\/strong><\/em><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> You can <strong>choose either of the three options<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/DO-NOT-SHOW-SUBTOTALS.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Subtotals to a Pivot Table\"  class=\"alignnone wp-image-2030 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/DO-NOT-SHOW-SUBTOTALS.png\" alt=\"Insert Subtotals to a Pivot Table\" width=\"286\" height=\"50\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/DO-NOT-SHOW-SUBTOTALS-PIVOT.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Subtotals to a Pivot Table\"  class=\"alignnone wp-image-2033 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/DO-NOT-SHOW-SUBTOTALS-PIVOT.png\" alt=\"Insert Subtotals to a Pivot Table\" width=\"329\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/DO-NOT-SHOW-SUBTOTALS-PIVOT.png 329w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/DO-NOT-SHOW-SUBTOTALS-PIVOT-274x300.png 274w\" sizes=\"(max-width: 329px) 100vw, 329px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-SUBTOTALS-AT-BOTTOM-OF-GROUP.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Subtotals to a Pivot Table\"  class=\"alignnone wp-image-2031 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-SUBTOTALS-AT-BOTTOM-OF-GROUP.png\" alt=\"Insert Subtotals to a Pivot Table\" width=\"286\" height=\"55\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-SUBTOTALS-AT-BOTTOM-OF-GROUP-PIVOT.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Subtotals to a Pivot Table\"  class=\"alignnone wp-image-2034 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-SUBTOTALS-AT-BOTTOM-OF-GROUP-PIVOT.png\" alt=\"Insert Subtotals to a Pivot Table\" width=\"326\" height=\"420\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-SUBTOTALS-AT-BOTTOM-OF-GROUP-PIVOT.png 326w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-SUBTOTALS-AT-BOTTOM-OF-GROUP-PIVOT-233x300.png 233w\" sizes=\"(max-width: 326px) 100vw, 326px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-ALL-SUBTOTALS-AT-TO-OF-GROUP.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Subtotals to a Pivot Table\"  class=\"alignnone wp-image-2032 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-ALL-SUBTOTALS-AT-TO-OF-GROUP.png\" alt=\"Insert Subtotals to a Pivot Table\" width=\"286\" height=\"56\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-ALL-SUBTOTALS-AT-TOP-OF-GROUP-PIVOT.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Insert Subtotals to a Pivot Table\"  class=\"alignnone size-full wp-image-2035\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-ALL-SUBTOTALS-AT-TOP-OF-GROUP-PIVOT.png\" alt=\"Insert Subtotals to a Pivot Table\" width=\"327\" height=\"361\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-ALL-SUBTOTALS-AT-TOP-OF-GROUP-PIVOT.png 327w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/SHOW-ALL-SUBTOTALS-AT-TOP-OF-GROUP-PIVOT-272x300.png 272w\" sizes=\"(max-width: 327px) 100vw, 327px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1080 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/728x90.gif\" alt=\"728x90\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you create a Pivot Table that has multiple fields in the Row Labels, Excel will automatically add a Subtotal to the top of the Group. What about if you want to change the Subtotals to show at the bottom of the Group or take the Subtotals out all together? Well you have that flexibility [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17480,"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":[87,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2027"}],"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=2027"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2027\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17480"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}