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