Show or hide items that have no data

1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
2. Click the title bar of the PivotTable list.
3. On the toolbar in the PivotTable list, click Commands and Options , and then click the Report tab.
4. Select or clear the Empty rows and Empty columns check boxes.