ShowAllItems Property

Applies To

PivotField object.

Description

True if all items in the PivotTable are displayed, even if they don't contain summary data. The default value is False. Read/write Boolean.

Example

This example causes the PivotTable to display all rows for the Month field, including months for which there's no data.

Worksheets(1).PivotTables("Pivot1") _
    .PivotFields("Month").ShowAllItems = True