The box PivotTable-Top is checked and other boxes are unchecked. The Report Connections dialog box appears. You can also find Report Connections in the dropdown list when you right click on the slicer.Ĭlick Report Connections in the Slicer group. You will find Report Connections in the Slicer group on the Ribbon. You can use the same slicer for both the PivotTables by connecting it to the bottom PivotTable also as follows − Observe that the filtering is applied only to the top PivotTable and not to the bottom PivotTable. Name the top PivotTable as PivotTable-Top and the bottom one as PivotTable-Bottom.Multiple PivotTables are created on separate sheets with Show Report Filter Pages.Ĭonsider the following PivotTables that are created from the same data − One PivotTable has been copied and pasted as an additional PivotTable. The PivotTables are created using the same data. You can connect different PivotTables to a Slicer, provided one of the following holds good − Sorting and Filtering options for the items displayed on the slicer.You can change the following for the slicer − The Slicer Settings dialog box appears.Īs you can observe, the following are fixed for the slicer − You can also find Slicer Settings in the dropdown list when you right click on the slicer.Ĭlick the Slicer Settings. You can find the Slicer Settings in the Slicer group on the Ribbon. You can use Slicer Settings to change the name of the slicer, change the slicer caption, choose whether to display the slicer header or not and set the sorting and filtering options for the items −Ĭlick the OPTIONS tab on the Ribbon. The name of the field that the slicer represents – Region remains as it is. Note − You have changed only the slicer caption, i.e. The Slicer Caption changes to Location and the same is reflected as header in the slicer. Type Location in the box and press Enter. You can change the Slicer Caption as follows −Ĭlick on the Slicer Caption box in the Slicer group on the Ribbon. It is the name of the field for which the slicer is inserted. The Slicer group on the Ribbon, in the Slicer Caption box, Region is displayed as the header of the slicer. By default, Slicer Caption is the name of the field that it represents. The Slicer Caption is the header that is displayed on the slicer. You can find the Slicer Caption box in the Slicer group. To view Slicer Tools, click on a slicer.Īs you can observe, under the Slicer Tools – OPTION tab, you have several options to change the look and feel of the slicer that include − Once you insert a slicer, Slicer Tools appear on the Ribbon with OPTIONS tab. Click on Remove “Region” in the dropdown list.Suppose you want to remove the slicer for the Region field. To clear the filter in a slicer, click on at the top-right corner of the slicer. To add/remove values of a field from the filter, keep the Ctrl key pressed and click on those buttons in the slicer of the field. PivotTable with summarized values for the selected items will be displayed. Selected items in the Slicers are highlighted. Keep Ctrl key pressed and click on March in the Slicer for Month. Keep Ctrl key pressed and click on West in the Slicer for Region.Ĭlick on February in the Slicer for Month. Only South will be highlighted in the Slicer – Region. Suppose you want to display the PivotTable only for the regions South and West and for the Months February and March.Ĭlick on South in the Slicer for Region. By default, all the values of a field are selected and hence all the buttons are highlighted. Filtering with SlicersĪs you can observe, each slicer has all the values of the field that it represents and the values are displayed as buttons. Slicer Tools appear on the Ribbon to work on the Slicer settings, look and feel. Slicers for each of the selected fields appear with all the values selected by default. It contains all the fields from your data table. Suppose you want to filter this PivotTable based on the fields – Region and Month.Ĭlick on ANALYZE under PIVOTTABLE TOOLS on the Ribbon.Ĭlick on Insert Slicer in the Filter group. Assume you have the following PivotTable with this data. To understand the usage of slicers, consider the example of sales data region-wise, month wise and salesperson-wise. Slicers stay visible with the PivotTable and so you will always know what fields are used for filtering and what values in those fields are shown or hidden in the filtered PivotTable. You can click on the buttons of a slicer to select/ unselect the values in the field. Slicer will have buttons denoting the values of the field that it represents. Slicers can be inserted for each of the fields that you want to filter. Using one or more slicers is a quick and effective way to filter your data.