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.
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.
Easily hide or show pivot table items, with the quick tip in this short Excel video tutorial. The written instructions are below the video
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.
Last updated: March 22, 2023 12:30 PM