This topic describes how to control the pivot table layout.

 

 

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 in the Designer is not saved in the Dashboard. However, the Dashboard allows you to specify the collapsed state to be applied in the Viewer by default.

To do this, use the Initial State button in the Data Ribbon group.

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