Pivot Filter

Possible Usage Scenarios

When you create a pivot table with known data and want to filter the pivot table, you need to learn how to use filters. It can help you effectively filter out the data you want. By using the Aspose.Cells Java API, you can add a filter on field values in Pivot Tables.

Add Filter in Pivot Table in Excel

To add a filter in a Pivot Table in Excel, follow these steps:

Select the PivotTable that you want to add a filter to.
Click on the drop-down arrow for the filter you want to add in the pivot table.
Select the “Top 10” from the drop-down menu.
Set the show mode and the number of filters.

Add Filter in Pivot Table

Sample Code

Clear Filter in Pivot Table in Excel

Clear filter in Pivot Table in Excel, follow these steps:

Select the PivotTable that you want to clear the filter from.
Click on the drop-down arrow for the filter you want to clear in the pivot table.
Select the “Clear Filter” from the drop-down menu.
If you want to clear all filters from the pivot table, you can also click on the “Clear Filters” button in the PivotTable Analyze tab on the ribbon in Excel.

Clear Filter in Pivot Table

Please see the following sample code. It sets the data and creates a PivotTable based on it. Then adds a filter on the row field of the pivot table. Finally, it saves the workbook in the output XLSX format. After executing the example code, a pivot table with a top‑10 filter is added to the worksheet. After adding a filter, when we need unfiltered data, we can clear the filter on a specific pivot field. After executing the code to clear the filter, the filter on the specific pivot field will be cleared. Please check the output XLSX.

Sample Code

Pivot Table Hide and Sort Data Show Report Filter Pages option