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 and use filter. It can help you filter out the data you want effectively. By using the Aspose.Cells Java API, you can add filter on field values in Pivot Tables.

Add Filter in Pivot Table in Excel

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

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

Add Filter in Pivot Table

Please see the following sample code. It sets the data and creates a PivotTable based on it. Then add a filter on the row field of the pivot table. Finally, it saves the workbook in output XLSX format. After executing the example code, a pivot table with top10 filter is added to the worksheet.

Sample Code

Clear Filter in Pivot Table in Excel

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

1. Select the PivotTable that you want to clear filter to.
2. Click on the drop-down arrow for the filter you want to clear in the pivot table.
3. Select the “Clear Filter” from the drop-down menu.
   
4. If you want to clear all filters from the pivot table, you can also click on the “Clear Filters” button in 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 add a filter on the row field of the pivot table. Finally, it saves the workbook in output XLSX format. After executing the example code, a pivot table with top10 filter is added to the worksheet. After adding a filter, when we need unfiltered data, we can clear the filter on a specific pivotfield. After executing the code to clear the filter, the filter on the specific pivotfield will be cleared. Please check the output XLSX.

Sample Code