Share via

PivotField.AutoShowCount Property

  • Article
Excel Developer Reference

Returns the number of top or bottom items that are automatically shown in the specified PivotTable field. Read-only Long.

Syntax

expression.AutoShowCount

expression   A variable that represents a PivotField object.

Example

This example displays a message box showing the AutoShow parameters for the Salesman field.

Visual Basic for Applications 
  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 report is showing " & rn & " " & _
            .AutoShowCount & " items in " & .Name & _
            " field by " & .AutoShowField
    Else
        MsgBox "PivotTable report is not using AutoShow for this field"
    End If
End With

See Also