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]"))