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.

Pivot_Layout_ExpandCollapseGroups

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 Initial State button in the Design ribbon tab.

Pivot_ExpandedState_Ribbon

This button invokes the popup menu that allows you to select whether column and row groups should be collapsed or expanded by default.

To specify the expanded state of groups in code, use the following properties:

Property Description
PivotDashboardItem.AutoExpandColumnGroups

Gets or sets whether column field values are expanded or collapsed by default in the current PivotDashboardItem.

PivotDashboardItem.AutoExpandRowGroups

Gets or sets whether row field values are expanded or collapsed by default in the current PivotDashboardItem.