Layout
- 3 minutes to read
This topic describes how to control the Pivot dashboard item layout, the visibility of totals and grand totals, and so on.
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 | Displays values from different Row dimensions in a single column. Note that in this case totals are displayed at the top of a group, and you cannot change totals position. | |
Tabular | Displays values from different Row dimensions in separate columns. |
To change the Pivot layout, go to Options menu | Layout and use the Layout option.
To specify the Pivot layout in code, use the PivotDashboardItem.LayoutType property.
Totals Visibility
Compact Layout
In the Compact layout type, it is impossible to hide Row Totals. Change the layout type to Tabular to achieve your goal.
Tabular Layout
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.
To manage the visibility of totals and grand totals, go to Options menu | Layout and use the following options:
- Row Totals / Row Grand Totals
- Column Totals / Column Grand Totals
Moreover, you can control the visibility of totals for individual dimensions/measures. To do this, go to Bindings menu, select the required data item and use its Options | Show Totals option.
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 position of totals/grand totals for the Pivot dashboard item. For instance, in the Image below the Pivot dashboard item whose row totals are moved from bottom to top.
To manage totals position, go to Options menu | Layout and use the following options:
- Row Totals Position
- Column Totals Position
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. In this case, you can hide summary values corresponding to specific measures. For instance, the image below shows the Pivot with hidden Quantity values.
To do this, go to Bindings menu, select the required measure and use its Options | Show Values option.
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 in rows.
To manage this position, go to Options menu | Layout and use the Values Position option.
To specify values position in code, use the PivotDashboardItem.ValuesPosition property.