PivotTable.DrillTo (Excel)

Enables you to drill to a location within an OLAP-based or PowerPivot-based cube hierarchy.

DrillTo (PivotItem, CubeField, PivotLine)

ActiveCell.PivotTable.DrillTo PivotItem:=, CubeField:=

Arguments

The following arguments are required:

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

CubeField (CubeField) - The target hierarchy being drilled to.

Optional arguments

The following argument is 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.