By default, applying multiple filters on the same field in a PivotTable isn't possible. However, there's a way to achieve this functionality:

1. Enable Allow Multiple Filters per Field:

* Right-click anywhere within your PivotTable.
* Select "PivotTable Options" from the menu.
* In the "PivotTable Options" dialog box, navigate to the "Totals & Filters" tab.
* Under "Filters," check the box for "Allow multiple filters per field."
* Click "OK" to save the changes.

2. Apply Filters:

Now you can use different filter types on the same field within your PivotTable:

* Label Filters: Use dropdown menus to filter by specific labels within a field (e.g., filter products to show only "Shirt" and "Hat").
* Value Filters: Filter based on numerical values within a field (e.g., filter sales amounts to show only values greater than $100).

Note: You cannot combine multiple Label Filters or Value Filters on the same field, but you can use one of each type for a more comprehensive filter.

Example:

Suppose you have a PivotTable with "Product" and "Sales" fields. You can:

* Use a Label Filter to show only "Shirt" and "Hat" products.
* Use a Value Filter on "Sales" to show only entries with sales greater than $100.

This combination allows you to filter your PivotTable data based on both product category and sales performance.