PivotTable.DrillTo(PivotItem, CubeField, Object) Method

Definition

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

public void DrillTo (Microsoft.Office.Interop.Excel.PivotItem PivotItem, Microsoft.Office.Interop.Excel.CubeField CubeField, object PivotLine);

Parameters

PivotItem
PivotItem

The member from which the drill operation is performed.

CubeField
CubeField

The target hierarchy being drilled to.

PivotLine
Object

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.

Applies to