There are two primary ways to use filters with PivotTables in Excel:

1. Using Field Headers (Label Filters):

This method allows you to filter data based on specific field values directly within the PivotTable itself.

Here's how it works:

* Click the down arrow next to a field name in the Row Labels or Column Labels section of your PivotTable. This reveals a dropdown menu with filtering options.
* Choose "Label Filters" from the menu.
* You'll see a list of unique values for that field.
* Check the boxes next to the values you want to include in your PivotTable and uncheck the ones you want to exclude.
* Click "OK" to apply the filter.

2. Using Slicers:

Slicers are a more interactive way to filter your PivotTable data. They provide a visual interface for selecting specific values across different fields.

Here's how to use them:

* Click anywhere in your PivotTable to activate the PivotTable Analyze tab.
* In the "Insert" group, click "Slicer."
* A window will appear listing all the fields in your PivotTable.
* Check the box(es) next to the fields you want to create slicers for.
* Click "OK" to insert the slicers.

Slicers will appear as separate objects on your worksheet. By clicking on individual items within a slicer, you can filter your PivotTable data based on those selections. You can also hold Ctrl and click on multiple items to filter by multiple values.

Additional Considerations:

* Enabling Multiple Filters: By default, PivotTables only allow filtering on one field at a time using label filters. However, you can enable filtering on multiple fields simultaneously. Right-click anywhere in the PivotTable and choose "PivotTable Options." In the "Totals and Filters" tab, check the box for "Allow multiple filters per field" and click "OK."
* Clearing Filters: To clear all filters applied to your PivotTable, right-click anywhere within the table and choose "Clear Filters."

By using either label filters or slicers, you can effectively filter and analyze your data within PivotTables, allowing you to focus on specific trends or insights.