PivotTable.DrillDown (Excel)

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

DrillDown (PivotItem, PivotLine)


ActiveCell.PivotTable.DrillDown PivotItem:=

Arguments

The following argument is required

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

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.