Expanded State

If the Columns or Rows section contains several data items, the Pivot column and row headers are arranged in a hierarchy and make up column and row groups.

wdd-pivot-expand-collapse.png

You can collapse and expand row and column groups using the Pivot_Layout_ExpandCollapse_DownArrow and Pivot_Layout_ExpandCollapse_UpArrow buttons. However, the current expanded state of column and row groups do not save in the dashboard definition. If necessary, you can specify the default expanded state using the following options from Options menu | Initial State:

  • Auto Expanded Column Groups - Specifies whether column groups should be collapsed or expanded by default;
  • Auto Expanded Row Groups - Specifies whether row groups should be collapsed or expanded by default.