Click the arrow in the cell with the item currently displayed in the page field.
Do one of the following:
Select a single item Click the item you want. In fields organized in levels, click beside a level to display the lower-level items, or click to display higher-level items, until the item you want appears in the list.
Select multiple items In reports based on OLAP source data, click the Select multiple items check box, and then click the items you want. In other types of reports, where this check box is not present, click OK and then double-click the field and hold down CTRL while you click the items you don't want to select in the Hide items box.
Display the summary of all items Click (All), if available. This option is unavailable for some source databases, or if the page field options are set to query the data for each item separately. To check the page field options, click Field Settings on the PivotTable toolbar, and then click Advanced.
Note When you display a different page in a PivotChart report or its associated PivotTable report, some chart formatting may be lost.
For some kinds of source data, you can display each PivotTable page on a separate worksheet. Click the report, click PivotTable on the PivotTable toolbar, and then click Show Pages. If the report has more than one page field, click the one you want.