Show or hide detail data for an item or field
- In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
- 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.
-
- Click Show Details
or Hide Details
on the toolbar.
Notes
- To show or hide lower-level items, select the row or column field or item, and then click Expand
or Collapse
on the toolbar.
- If you don't want users to display detail data, you can restrict access to detail in the browser.