Free Support Forum - aspose.com

Collapse drill down on open

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

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);