Key Skills > Pivot Tables > Filters

Pivot Table Filter Topics on 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.

Author: Debra Dalgleish

Pivot Table Filter Tutorials

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

1 --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 top 10 filter

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

Excel 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.s
Excel File: Pivot Table Top 10 Filters workbook (has 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. Pivot tables are based on 2 different data sources. 
Excel File:
Filter All Pivot Tables With One Slicer (has macros)


About Debra


Last updated: August 14, 2022 8:58 PM