ShowAllItems Property Example

This example displays all rows for the Month field in the first PivotTable report on worksheet one, including months for which there’s no data.

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