{"id":268,"date":"2014-09-24T16:54:21","date_gmt":"2014-09-24T14:54:21","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=268"},"modified":"2024-06-07T21:50:30","modified_gmt":"2024-06-07T19:50:30","slug":"group-sales-with-a-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-sales-with-a-pivot-table\/","title":{"rendered":"Group Sales with a Pivot Table"},"content":{"rendered":"<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\/group-sales-with-a-pivot-table\/#Group_Sales_with_a_Pivot_Table\" title=\"Group Sales with a Pivot Table\">Group Sales with a Pivot Table<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Group_Sales_with_a_Pivot_Table\"><\/span>Group Sales with a Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A <a class=\"wpil_keyword_link\" title=\"Pivot Table\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> allows you to <em>Group<\/em> your transactional sales values by any range that you want.\u00a0 You can then summarize each sales group and see the total sales and the number of transactions that they have produced.\u00a0 This is useful for pricing analysis.<\/p>\n<p><span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Group-Sales.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>This is our set of data that we will use:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23405\" title=\"Group Sales with a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-01.jpg\" alt=\"Group Sales with a Pivot Table\" width=\"606\" height=\"501\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-01.jpg 606w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-01-300x248.jpg 300w\" sizes=\"(max-width: 606px) 100vw, 606px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Drop\u00a0<strong>Sales\u00a0<\/strong>into\u00a0<strong>Rows<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23406\" title=\"Group Sales with a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-02.jpg\" alt=\"Group Sales with a Pivot Table\" width=\"793\" height=\"533\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-02.jpg 793w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-02-300x202.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-02-768x516.jpg 768w\" sizes=\"(max-width: 793px) 100vw, 793px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span><strong>Right click<\/strong> on your Pivot Table and select <strong>Group<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23407\" title=\"Group Sales with a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-03.jpg\" alt=\"Group Sales with a Pivot Table\" width=\"404\" height=\"539\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-03.jpg 404w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-03-225x300.jpg 225w\" sizes=\"(max-width: 404px) 100vw, 404px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>You can start and end at any value. Click\u00a0<strong>OK<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23408\" title=\"Group Sales with a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-04.jpg\" alt=\"Group Sales with a Pivot Table\" width=\"347\" height=\"417\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-04.jpg 347w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-04-250x300.jpg 250w\" sizes=\"(max-width: 347px) 100vw, 347px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Once the groupings are in place, drag\u00a0<strong>Sales\u00a0<\/strong>into\u00a0<strong>Values<\/strong> twice<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23409\" title=\"Group Sales with a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-05.jpg\" alt=\"Group Sales with a Pivot Table\" width=\"598\" height=\"556\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-05.jpg 598w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-05-300x279.jpg 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5: <\/strong><\/span><strong>Right click<\/strong> on the first\u00a0<strong>Count of Sales<\/strong> column and select\u00a0<em><strong>Summarize Values By &gt; Sum<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23410\" title=\"Group Sales with a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-06.jpg\" alt=\"Group Sales with a Pivot Table\" width=\"760\" height=\"584\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-06.jpg 760w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-06-300x231.jpg 300w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/p>\n<p>You now have your grouped sales data ready!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23411\" title=\"Group Sales with a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-07.jpg\" alt=\"Group Sales with a Pivot Table\" width=\"742\" height=\"549\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-07.jpg 742w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Group-Sales-with-a-Pivot-Table-07-300x222.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Group Sales with a Pivot Table A Pivot Table allows you to Group your transactional sales values by any range that you want.\u00a0 You can then summarize each sales group and see the total sales and the number of transactions that they have produced.\u00a0 This is useful for pricing analysis. download workbookGroup-Sales.xlsx This is our [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17689,"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":[19,4],"tags":[89,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/268"}],"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=268"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/268\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17689"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}