The Pivot dashboard item displays a cross-tabular report that presents multi-dimensional data in an easy-to-read format.
Providing Data
The image below shows a sample Pivot dashboard item that is bound to data.
To bind the Pivot dashboard item to data, click a placeholder contained in one of the available data sections and select the required data source field in the Binding section of the invoked data item menu.
The table below lists and describes the Pivot’s data sections.
|
Section
|
Processed as
|
Description
|
|---|---|---|
|
Values
|
Measure
|
Contains data items used to calculate values displayed in the pivot table.
|
|
Columns
|
Dimension
|
Contains data items whose values are used to label columns.
|
|
Rows
|
Dimension
|
Contains data items whose values are used to label rows.
|
Interactivity
To enable interaction between the Pivot and other dashboard items, you can use the interactivity features. These features include Master Filtering.
Master Filtering
Data displayed in the Pivot dashboard item can be filtered by other master filter items. The image below displays the Pivot dashboard item filtered by Tree View.
You can prevent the pivot from being affected by other master filter items using the Ignore Master Filters button in the Pivot’s Interactivity menu.
Layout
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
|
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.
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.
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 the Bindings menu, select the required data item, and use its Options | Show Totals option.
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 the totals position, go to Options menu | Layout and use the following options:
- Row Totals Position.
- Column Totals Position.
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 the Bindings menu, select the required measure, and use its Options | Show Values option.
Values Visibility
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 the Options menu | Layout and use the Values Position option.
Expanded State
If the Columns or Rows section contains several data items, the Pivot column and row headers are arranged in a hierarchy and makeup column and row groups.
You can collapse and expand row and column groups using the 
and 
buttons. However, the current expanded state of column and row groups does not save in the dashboard definition. If necessary, you can specify the default expanded state using the following options from the Options menu | Initial State:
and buttons. However, the current expanded state of column and row groups does not save in the dashboard definition. If necessary, you can specify the default expanded state using the following options from the Options menu | Initial State:- Auto Expanded Column Groups - Specifies whether column groups should be collapsed or expanded by default;
- Auto Expanded Row Groups - Specifies whether row groups should be collapsed or expanded by default.