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