This helps protect our community. Learn more

Excel - One Slicer for Multiple PivotTables with Different Data Sources - Apply the Same Filter

133K subscribers

175K views 3 years ago

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted... Thank you! 👍👍 Download the featured file here: https://www.bluepecantraining.com/wp-... In this video I demonstrate how to filter multiple PivotTables based on different data sources using one slicer. The key step in this process is to employ Excel's data model which allows you to create relationships between the different data sources. ------------------------

...more

Excel - One Slicer for Multiple PivotTables with Different Data Sources - Apply the Same Filter

2.2KLikes

175,606Views

2022Jan 10

House all of Your Data in all of these Sheets in Excel Tables

1:01

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

1:52

Create a Slicer

4:06

Report Connections

5:58

Transcript

Follow along using the transcript.

Chester Tugwell

133K subscribers

Excel - One Slicer for Multiple PivotTables with Different Data Sources - Apply the Same Filter

Key moments View all

House all of Your Data in all of these Sheets in Excel Tables

House all of Your Data in all of these Sheets in Excel Tables

House all of Your Data in all of these Sheets in Excel Tables

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Slicer

Create a Slicer

Create a Slicer

Report Connections

Report Connections

Report Connections

Chester Tugwell

Excel - One Slicer for Multiple PivotTables with Different Data Sources - Apply the Same Filter

Comments 104

Key moments

House all of Your Data in all of these Sheets in Excel Tables

House all of Your Data in all of these Sheets in Excel Tables

House all of Your Data in all of these Sheets in Excel Tables

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Slicer

Create a Slicer

Create a Slicer

Report Connections

Report Connections

Report Connections

Description

Key moments View all

House all of Your Data in all of these Sheets in Excel Tables

House all of Your Data in all of these Sheets in Excel Tables

House all of Your Data in all of these Sheets in Excel Tables

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Pivot Table for the Sales Data and a Pivot Table for the Returns Data

Create a Slicer

Create a Slicer

Create a Slicer

Report Connections

Report Connections

Report Connections

Chester Tugwell

Transcript

Key moments

Key moments