Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotItem.DrillTo Method

Office 2007
The DrillTo method supports drilling to a specified PivotField from a PivotItem.

Version Information
 Version Added:  Excel 2007

Syntax

expression.DrillTo(PivotItemName)

expression   A variable that represents a PivotItem object.

Parameters

NameRequired/OptionalData TypeDescription
PivotItemNameRequiredStringThe name of the PivotItem to drill to.

Remarks

For OLAP data sources, the PivotField being drilled to has to be in the same hierarchy as the PivotItem being drilled or, if multiple attribute hierarchies are placed next to each other on rows or columns, the PivotField being drilled to has to be one of the attribute hierarchies that are next to each other; no user hierarchies can be placed in between the PivotField of the PivotItem being drilled and the PivotField being drilled to. If these conditions are not met, a run-time error is returned.




Community Additions

Show: