Home > Pivot > Filters > Interactive

Interactive Excel Pivot Table Demo

After you've created an Excel pivot table, you can use the Report Filters, or Row and Column filters, to limit the data that is being summarized in the pivot table.

drop down arrows visible

Try the Interactive Pivot Table

In the interactive pivot table below, click the drop down arrows on the field buttons, to operate the filters.

You can download a copy of the file, to test the pivot table features on your own computer.

Quick Way to Hide or Show Pivot Items

Easily hide or show pivot table items, with the quick tip in this short Excel video tutorial. The written instructions are below the video

Using Report Filters 

After you summarize your data by creating an Excel Pivot Table, you can focus on specific portions of the data by using Report Filters.

See the steps for adding and applying pivot table report filters in this short video tutorial. There are written steps on the Pivot Table Report Filters page.

More Pivot Table Resources

Pivot Table Date Filters

Manually Move Pivot Items

FAQs - Pivot Tables

Pivot Table Introduction

Clear Old Items in Pivot Table






Last updated: March 22, 2023 12:30 PM