PivotTable.DrillUp (Excel)

Enables you to drill up into the data within an OLAP-based or PowerPivot-based cube hierarchy.

DrillUp (PivotItem, PivotLine, LevelUniqueName)

ActiveCell.PivotTable.DrillUp PivotItem:=

Arguments

The following argument is required

PivotItem (PivotItem) - The member from which the drill up is performed.

Optional arguments

The following arguments are optional

PivotLine (PivotLine) - Specifies the line in the PivotTable where the operation starting member resides. In cases where PivotLine is not specified, defaults to the top PivotLine where the member appears.

LevelUniqueName (String) - The target for a multi-level drill up. The default action, if not specified, is a one level drill up.