Collapse drill down on open

Aspose.Cells Product Family
1

I want the drill down to be collapsed by default inside the pivot table.

2

Hi,


I think you may try to use PivotField.HideItemDetail() method for your need.

e.g
pivotTable.RowFields[0].HideItemDetail(0, true);
pivotTable.RowFields[0].HideItemDetail(1, true);