TreeviewControl Property Example
This example sets the first cube field control to “drilled” for the states of California and Maryland in the second PivotTable report on the active worksheet.
ActiveSheet.PivotTables("PivotTable2") _
.CubeFields(1).TreeviewControl.Drilled = _
Array(Array("", ""), _
Array("[state].[states].[CA]", _
"[state].[states].[MD]"))