Layout

This topic describes how to control the Pivot dashboard item layout, the visibility of totals and grand totals, etc.

Layout Type

If the Pivot dashboard item contains a hierarchy of dimensions in the Rows section, you can specify the layout used to arrange values corresponding to individual groups.

Layout type Example Description
Compact Pivot_CompactLayout Displays values from different Row dimensions in a single column. Note that in this case totals are shown at the top of a group, and you cannot change totals position.
Tabular Pivot_TabularLayout Displays values from different Row dimensions in separate columns.

Use the Layout button in the Layout group on the Design ribbon tab of the Pivot Tools contextual tab set to change the Pivot layout.

Pivot_LayoutButtonRibbon

To specify the Pivot layout in code, use the PivotDashboardItem.LayoutType property.

Totals Visibility

You can control the visibility of totals and grand totals for the entire Pivot dashboard item. For instance, the image below displays the Pivot dashboard item with the disabled row totals.

Pivot_DisableRowTotals_Example

To manage the visibility of totals and grand totals, use the Totals and Grand Totals buttons in the Layout group on the Design ribbon tab of the Pivot Tools contextual tab set, respectively.

Pivot_TotalsVisibilityRibbon

These buttons invoke a popup menu that allows you to manage the visibility of column and row totals/grand totals separately.

Moreover, you can control the visibility of totals for individual dimensions/measures by using the data item's context menu (Show Totals and Show Grand Totals options).

Pivot_ShowTotals_DataItemMenu

To specify the totals visibility in code, use the following properties:

Property Description
PivotDashboardItem.ShowRowTotals Gets or sets whether to display the Pivot row totals calculated for outer row data items.
PivotDashboardItem.ShowColumnTotals Gets or sets whether to display the Pivot column totals calculated for outer column data items.
PivotDashboardItem.ShowRowGrandTotals Gets or sets whether to display the Pivot row grand totals calculated against all the rows.
PivotDashboardItem.ShowColumnGrandTotals Gets or sets whether to display Pivot column grand totals calculated against all the columns.
DataItem.ShowTotals Gets or sets whether to show totals for the current data item.
DataItem.ShowGrandTotals Gets or sets whether to show grand totals for the current measure.

Totals Position

If necessary, you can change the Pivot dashboard item's totals/grand totals position. For instance, in the image below the row totals are moved from the bottom to the top.

Pivot_RowTotals_Bottom_Top

To manage totals position, use the Row Totals Position and Column Totals Position buttons in the Design ribbon tab.

Pivot_TotalsPositionRibbon

In code, use the following properties:

Property Description
PivotDashboardItem.RowTotalsPosition Gets or sets the position of row totals/grand totals in the Pivot dashboard item.
PivotDashboardItem.ColumnTotalsPosition Gets or sets the position of column totals/grand totals in the Pivot dashboard item.

Values Visibility

The Pivot dashboard item can contain several measures in the Values section to hide summary values corresponding to specific measures. For instance, the image below shows the Pivot with hidden Quantity values.

Pivot_ValuesVisibility

To do this, use the Show Values command in the measure menu.

Pivot_ValuesVisibility_Menu

In code, use DataItem.ShowValues.

Values Position

The Pivot dashboard item allows you to control the position of headers used to arrange summary values corresponding to different measures. For instance, you can display values in columns or rows.

Pivot_ValuesPosition

To manage this position, use the Values Position drop-down button in the Layout group on the Design ribbon tab of the Pivot Tools contextual tab set.

Pivot_ValuesPositionRibbon

To specify values position in code, use the PivotDashboardItem.ValuesPosition property.

Reset Layout Options

To reset layout options, click the Reset Layout Options button in the Layout group on the Design ribbon tab of the Pivot Tools contextual tab set.

Pivot_ResetLayoutOptionsRibbon