Show or hide items that have no data

1. Click the title bar of the PivotTable list.
2. On the toolbar in the PivotTable list, click Commands and Options , and then click the Report tab.
3. Select or clear the Empty rows and Empty columns check boxes.