Key Skills > Pivot Tables > Filters

Pivot Table Filter Topics on Contextures

Debra Dalgleish - Contextures

Use Excel Pivot Table filters to quickly focus on specific data in your pivot table summary. Filter by date, value, top or bottom rankings, and more.

drop down list of filter types

Pivot Table Filter Videos

Here's one of my top Excel pivot table filter videos, and almost all of my Excel pivot table tutorial pages include a video too.

This short video shows the three types of pivot table date filters, and how to use them. There are written steps below the video

Pivot Table Filter Tutorials

These popular tutorials show how to use the different types of Excel Pivot Table filters.

pivot filters

1 - Use Pivot Table Top 10 Filters to focus on the top 10, bottom 10 or a specific portion of the total values in your data.

2 --How to Use Excel Pivot Table Date Range Filter- Steps, Video -- Use Excel Pivot Table Filters for selected dates, date range, dynamic dates like last week. Stop date grouping in drop down. Easy steps, video, Excel file

2 --Excel Pivot Table Filters - Top 10 -- Use Excel Pivot Table Filters to focus on the top 10, bottom 10 or a specific portion of the total values in your data.

3 --How to Use Excel Pivot Table Label Filters -- How to apply multiple filters on one Excel pivot field, how to show or hide the filter arrows. Short video shows steps

4 --Excel Pivot Table Report Filter Tips and Tricks -- How to use Excel Pivot Table Report Filters to focus on a specific section of your data. Change Report filter layout, to save space on worksheet

5 --Excel Pivot Table Report Filters Macros -- Sample macros to change Excel pivot table report filters

Pivot Table Filters - Sample Files

Here are the download links for a couple of my latest Excel pivot table filter sample workbooks, and most of the Excel tutorial pages include a sample file too.

More Workbooks: For even more pivot table sample files, go to the Excel Sample Files page, and scroll down to the Pivot Table section.

pivot filters

Top 10 Filters: To experiment with the pivot table Top 10 filters, you can download the sample file. The file is in xlsm format, and contains macros.

PT0049 Filter All Pivot Tables With One Slicer -- Select a region on the main Slicer, and all 3 pivot tables are filtered for that region. Click here to download the Filter All Pivot Tables With One Slicer sample file. (It has macros)

Explore More Pivot Table Topics

Pivot Layout
Pivot Formulas
Create Pivot
Pivot Charts
Pivot Macros
Pivot Format
Pivot Errors

 

 

Get Monthly Excel Tips!

Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.

Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!

Explore Excel Topics

Data
Pivot Tables
Data Validation
Formulas and Functions
Macros
Charts
Formatting
Filters

 

Last updated: June 24, 2026 11:59 AM