Expand and Collapse Groups in Pivot Tables

Expand/Collapse Values Groups

To expand/collapse value groups, do one of the following.

• Click the corresponding expand button.

  

• Right-click a value that has nested values, and select the required Expand or Collapse command from the menu that opens.

  

Expand/Collapse Fields

To expand/collapse a group of fields, click a corresponding field expand button.