Show or hide items

1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
2. Do one of the following:
   • To show or hide the lower-level items of a specific item in the row or column axis, click the expand indicator ( or box) next to the item.
   • To show or hide the lower-level items for all items in a row or column field, click the field label, and then click Expand or Collapse on the toolbar.

Notes

• If the or box is not visible next to the item, select the Expand indicator check box on the Behavior tab in the Commands and Options dialog box. If after selecting the check box you don't see an expand indicator next to an item, the item might be at the lowest level available for the source data.

• To show or hide details, select the item or field, and then click Show Details or Hide Details on the toolbar.