DrilledDown Property Example
This example sets the flags to “not drilled” for all items in the state field in the third PivotTable report on the active worksheet.
ActiveSheet.PivotTables("PivotTable3") _ .PivotFields("state").DrilledDown = False