Display a different page in a PivotTable or PivotChart page field

Microsoft Office Excel 2003

  • Click the arrow Field 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 Plus box beside a level to display the lower-level items, or click Minus box 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 Button image 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.

    ShowTip

    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.