Show or hide detail data for an item or field

  1. Do one of the following:
  2. Click Show Details or Hide Details on the PivotTable list toolbar.

Note   To show or hide lower-level items, select the row or column field or item, and then click Expand or Collapse on the toolbar.