AutoShowField Property
Applies To
PivotField object.
Description
Returns the name of the data field used to determine the top or bottom items that are automatically shown in the pivot field. Read-only String.
Example
This example displays a message box showing the AutoShow parameters for the Salesman field.
With Worksheets(1).PivotTables(1).PivotFields("salesman")
If .AutoShowType = xlAutomatic Then
r = .AutoShowRange
If r = xlTop Then
rn = "top"
Else
rn = "bottom"
End If
MsgBox "PivotTable is showing " & rn & " " & _
.AutoShowCount & " items in " & .Name & _
" field by " & .AutoShowField
Else
MsgBox "Pivot table is not using AutoShow for this field"
End If
End With