The Web Dashboard allows you to configure the Pivot's layout. You can expand and collapse groups, specify the totals visibility, etc.
If the Columns section or Rows section contains several data items, the pivot table column and row headers are arranged in a hierarchy, and make up column and row groups.
You can collapse and expand row and column groups using the and buttons.
The actual collapsed state of column and row groups is not saved in the dashboard. However, the Web Dashboard allows you to specify the collapsed state by default. You can also control the visibility of totals and grand totals. To do this, open the Layout section in the Pivot's Options menu.
The following layout settings are available.
|