Add Filter in Pivot Table

Possible Usage Scenarios

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

Add Filter in Pivot Table Using Aspose.Cells for Python Excel Library

Please see the following sample code. It sets the data and creates a PivotTable based on it. Then it adds 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 a Top 10 filter is added to the worksheet.

Sample Code