❶ Select a cell in the first Pivot Table. Step-2: Inserting Slicer for Multiple Pivot Tables Under the Values section, keep the Sum of Sales.Īfter that, you will get your second Pivot Table having two columns.This time select the Region and Sales columns in the PivotTable Fields dialog box.

After that pick up a cell in the Location This will be the destination of the second Pivot Table.

Now insert the table range again in the Table/Range.

The ‘PivotTable from table or range’ dialog box will open.

Again, go to Insert ➤ PivotTable ➤ From Table/Range.

Then put Months under the Rows section and Sum of Sales in the ValuesĪfter that, you will get the first Pivot Table having two columns.

For the first Pivot Table, select the Sales and Month column in the PivotTables Field dialog box.

Then select New Worksheet and click OK.

Now insert the table range in the Table/Range.

The ‘PivotTable from table or range’ dialog box will appear.

First, go to Insert ➤ PivotTable ➤ From Table/Range.

Now follow the steps below to turn the dataset above into a pivot table.

Here, I’m going to create two pivot tables for this instance. To demonstrate to you how to connect a slicer to multiple pivot tables, I will be using the following dataset as source data. Steps to Connect Slicer for Multiple Pivot Tables in Excel Step-1: Creating Multiple Pivot Tables to Connect Slicer Other than filtering data, the slicer also shows the current state of filtering an Excel Table or a Pivot Table. It’s the quickest way to Filter out data. Slicer is a sophisticated way to Filter Excel Tables as well as Pivot Tables.

How to use pivot charts in excel 2013