InnerDetail Property

Applies To

PivotTable Object.

Description

Returns or sets the name of the field which will be shown as detail when the ShowDetail property is True for the innermost row or column field. Read-write.

See Also

ShowDetail Property.

Example

This example displays the name of the field that will be shown as detail when the ShowDetail property is True for the innermost row field or column field.


Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
MsgBox pvtTable.InnerDetail