{"id":24810,"date":"2021-10-27T12:52:33","date_gmt":"2021-10-27T10:52:33","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24810"},"modified":"2024-02-06T15:49:19","modified_gmt":"2024-02-06T14:49:19","slug":"use-one-slicer-for-two-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-one-slicer-for-two-pivot-tables\/","title":{"rendered":"Use One Slicer for Two Excel Pivot Tables"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/One-slicer.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25086\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/One-slicer.png\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/One-slicer.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/One-slicer-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/One-slicer-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>I had a scenario wherein I wanted to use <strong>one slicer for two pivot tables<\/strong> as that would look so cool! You can select items in the slicer and the data will get filtered in all the Pivot Tables.<\/p>\n<p>Let me show you this trick so that it will only take a couple of steps to set this up!<\/p>\n<ul>\n<li>Create the first Pivot Table.<\/li>\n<li>Copy-paste the first Pivot Table to create the second Pivot Table.<\/li>\n<li>Insert a slicer<\/li>\n<li>Link the slicer to both the tables.<\/li>\n<\/ul>\n<p>Don&#8217;t forget to download the <strong>Exercise Workbook<\/strong> below and follow along with us!<\/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\/08\/Use-one-slicer-for-two-pivot-tables.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables.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\">Use-one-slicer-for-two-pivot-tables.xlsx<\/span><\/a><\/strong><\/p>\n<p class=\"line-two\">\n<\/div>\n<hr \/>\n<p>Here is our current <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> setup:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-21-at-12.56.06-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25050\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-21-at-12.56.06-PM.png\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"1120\" height=\"500\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-21-at-12.56.06-PM.png 1120w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-21-at-12.56.06-PM-300x134.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-21-at-12.56.06-PM-1024x457.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-21-at-12.56.06-PM-768x343.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong> <\/span>Click anywhere on the data table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25054\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer01.png\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"1209\" height=\"469\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer01.png 1209w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer01-300x116.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer01-1024x397.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer01-768x298.png 768w\" sizes=\"(max-width: 1209px) 100vw, 1209px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 2:<\/strong> <\/span>Go to <strong>Insert<\/strong> &gt; <strong>PivotTable<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25055\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer02.png\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"981\" height=\"145\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer02.png 981w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer02-300x44.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer02-768x114.png 768w\" sizes=\"(max-width: 981px) 100vw, 981px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 3: <\/strong><\/span>Place the Pivot Table in a\u00a0<strong>New or Existing Worksheet\u00a0<\/strong>and click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Create-PivotTable.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25052\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Create-PivotTable.jpeg\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"388\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Create-PivotTable.jpeg 388w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Create-PivotTable-300x268.jpeg 300w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 4: <\/strong><\/span>Drag and drop the following:<\/p>\n<ul>\n<li>Financial Year and Sales Region in Rows field<\/li>\n<li>Sum of Sales in Values field<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-24882\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-01.jpg\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"918\" height=\"528\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-01.jpg 918w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-01-300x173.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-01-768x442.jpg 768w\" sizes=\"(max-width: 918px) 100vw, 918px\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 5: <\/strong><\/span> Select any cell inside the Pivot Table and go to <em><strong>PivotTable Analyze &gt; Select &gt; Entire PivotTable<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-24883\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-02.jpg\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"940\" height=\"245\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-02.jpg 940w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-02-300x78.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-02-768x200.jpg 768w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 6: <\/strong><\/span> Right-click and select <strong>Copy<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-24884\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-03.jpg\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"547\" height=\"497\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-03.jpg 547w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-03-300x273.jpg 300w\" sizes=\"(max-width: 547px) 100vw, 547px\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 7:<\/strong><\/span> Pick an empty space and select <strong><em>Home &gt; Clipboard &gt; Paste<\/em><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-24885\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-04.jpg\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"847\" height=\"635\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-04.jpg 847w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-04-300x225.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-04-768x576.jpg 768w\" sizes=\"(max-width: 847px) 100vw, 847px\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 8:<\/strong><\/span> Now set up the second Pivot Table by placing inside <strong>Rows: SALES PERSON\u00a0<\/strong>and <strong>SALES QTR<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-24886\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-05.jpg\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"641\" height=\"568\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-05.jpg 641w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-05-300x266.jpg 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 9:<\/strong><\/span> Click anywhere on the PivotTable, go to <strong>PivotTable Analyze &gt; Insert Slicer<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25056\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer03.png\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"1019\" height=\"144\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer03.png 1019w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer03-300x42.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer03-768x109.png 768w\" sizes=\"(max-width: 1019px) 100vw, 1019px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 10:<\/strong><\/span> Select <strong>Sales Month<\/strong> and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25057\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer04.png\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"881\" height=\"416\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer04.png 881w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer04-300x142.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer04-768x363.png 768w\" sizes=\"(max-width: 881px) 100vw, 881px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 11:<\/strong><\/span> Right-click on the slicer and select <strong>Report Connections<\/strong>&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25058\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer05.png\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"819\" height=\"601\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer05.png 819w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer05-300x220.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer05-768x564.png 768w\" sizes=\"(max-width: 819px) 100vw, 819px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 12:<\/strong><\/span> <strong>Select both the Pivot Tables<\/strong> and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25059\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer06.png\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"416\" height=\"236\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer06.png 416w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/10\/Slicer06-300x170.png 300w\" sizes=\"(max-width: 416px) 100vw, 416px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now try it out! Click on\u00a0<strong>March\u00a0<\/strong>in your slicer and both pivot tables are updated at the same time!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Use One Slicer for Two Excel Pivot Tables\"  class=\"alignnone size-full wp-image-24887\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-06.jpg\" alt=\"Use One Slicer for Two Excel Pivot Tables\" width=\"858\" height=\"463\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-06.jpg 858w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-06-300x162.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/08\/Use-one-slicer-for-two-pivot-tables-06-768x414.jpg 768w\" sizes=\"(max-width: 858px) 100vw, 858px\" \/><\/p>\n<p>You can choose the Report Connections options to link slicer to multiple pivot tables at once and use a single slicer to operate the pivot tables. This will make your report hassle-free and not messy.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/\" target=\"_blank\"><strong>Click here<\/strong><\/a> to learn more about Pivot Table Slicers!<\/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 noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I had a scenario wherein I wanted to use one slicer for two pivot tables as that would look so cool! You can select items in the slicer and the data will get filtered in all the Pivot Tables. Let me show you this trick so that it will only take a couple of steps [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":25087,"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":[779,778],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24810"}],"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=24810"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24810\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25087"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}