Show or hide detail data for an item or field

1. Do one of the following:

   • To show or hide detail data for a cell, or an item at the lowest level, select the item or cell.

   • To show or hide detail data for a row or column field, select the row or column field.
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.