Pivot Table Hide and Sort data

Aspose.Cells supports hiding and sorting data in the pivot table. The following code snippet demonstrates this feature by sorting the Score column in descending order and then hiding the rows with a score less than 60.

The source and output excel files used in the code snippet are attached for reference.

Source File

Output File

Pivot Table and Source Data Add calculated field in Pivot Table