HiddenLevels Property Example

This example hides the top two levels of the hierarchy in the second cube field in the first PivotTable report on the active worksheet.

ActiveSheet.PivotTables(1).CubeFields(2).HiddenLevels = 2