There are two main methods to create PivotTables with multiple report filters in Excel:

1. Using Filters Area:

1. Create a PivotTable: Start by creating a PivotTable from your data range. You can do this by selecting the data and going to the "Insert" tab, then clicking "PivotTable."
2. Add Fields to Filters: Drag the fields you want to filter by to the "Filters" area of the PivotTable layout. This area is typically located on the right side of the PivotTable.
3. Apply Filters: Click the dropdown arrow next to the filter field. You can then select the specific items you want to see in your report. You can choose multiple options for filtering.

2. Using Show Report Filter Pages:

1. Create a PivotTable: Similar to method 1, create a PivotTable from your data.
2. Show Report Filter Pages: With any cell within the PivotTable selected, navigate to the "Analyze" or "Options" tab (depending on your Excel version). Click the dropdown arrow next to "Options" (or directly on "Options") and select "Show Report Filter Pages..."
3. Choose Filtering Field: A window will appear showing the fields currently in the Filters area. Select the field you want to create separate reports for (e.g., Region).
4. Generate Reports: Click "OK." This will create a new worksheet for each item within the chosen filter field (e.g., separate reports for each Region). Each new worksheet will be a PivotTable filtered specifically for that item.

Here are some additional points to consider:

* You can combine both methods for even more granular filtering.
* Filter reports update dynamically as you change selections within the original PivotTable or individual filter reports.
* Remember, these reports are not directly linked. If you modify the layout of the original PivotTable, the report layouts won't automatically change in the separate sheets.

By using these methods, you can create PivotTables that allow for easy exploration and analysis of your data based on multiple filtering criteria.