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