Expand and Collapse Groups in Pivot Tables

Expand/Collapse Groups of Values

To expand/collapse groups of values, do one of the following:

  • Click a corresponding expand button:

    EU_XtraPivotGrid_ExpandButtons

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

    EU_XtraPivotGrid_ExpandMenu

Expand/Collapse Fields

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

EU_XtraPivotGrid_FieldExpandButton