Add filter in pivot table
- Thread starter aayu
- Start date
Monty
Well-Known Member
Unable to op3n your excel file...
To add filters in the top of a pivot table, you can follow these steps:
1. Click anywhere inside the pivot table to select it.
2. Go to the "PivotTable Analyze" or "Options" tab on the Excel ribbon.
3. In the "Filter" group, click on the "Insert Slicer" button.
4. A dialog box will appear with a list of fields from your pivot table. Check the boxes next to the fields you want to add as filters.
5. Click on "OK" to insert the slicers.
6. The slicers will appear in a separate window on your worksheet. You can drag and resize them to place them at the top of your pivot table.
7. Use the slicers to filter the data in your pivot table by selecting the values you want to include or exclude.
I hope this helps! Let me know if you have any other questions.
To add filters in the top of a pivot table, you can follow these steps:
1. Click anywhere inside the pivot table to select it.
2. Go to the "PivotTable Analyze" or "Options" tab on the Excel ribbon.
3. In the "Filter" group, click on the "Insert Slicer" button.
4. A dialog box will appear with a list of fields from your pivot table. Check the boxes next to the fields you want to add as filters.
5. Click on "OK" to insert the slicers.
6. The slicers will appear in a separate window on your worksheet. You can drag and resize them to place them at the top of your pivot table.
7. Use the slicers to filter the data in your pivot table by selecting the values you want to include or exclude.
I hope this helps! Let me know if you have any other questions.
