PivotTable.InnerDetail (Excel)

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

This property isn't available for OLAP data sources.

ActiveCell.PivotTable.InnerDetail =