Pivot Table

A Pivot Table displays aggregated data structured in a tree organized as logical hierarchies and levels. It allows you to expand and collapse level members to reveal their sub-totals and children.

Ask your product development team about setting up natural hierarchies for your daily use. Follow the link to read more about auto-expand.

Quick Start

Adding a New Pivot Table

The location of the "Pivot Table" widget depends on a particular implementation.

In many cases, the "Pivot Table" widget can be added from the empty dock or widgets library.

In the following example, the first pivot table is added form the empty dock, the second from the "Widgets" menu. If there are multiple cubes connected to your application, you must select the cube you need for the table.

To reuse an existing Pivot Table, drag it from the Bookmarks Tree.

Data editing

You can use the Content Editor widget to configure the data selection in your Pivot Table. Pleaser refer to the Content Editor page for more information.

It is also possible to achieve specific requirements, such as:

• to change captions of measures
• to rename aggregation levels
• to apply complex conditional formatting
• or to apply virtually any kind of transformation to the data

You can view and further edit the query behind the Pivot Table using the Mdx Editor.

Saving a Pivot Table

You can save the widget using "Save as" action available for Widgets. When you save a widget, you can access it again from the Bookmarks Tree widget.

Changing the layout

The "Pivot Table" widget supports general Table Layout Controls, such as changing column headers or captions.

In addition, the "Pivot Table" allows you to switch to a display similar to Tabular View, see Display as Columns below.

Display as Columns

Use the "Display as Columns" column's context menu to change the display of the aggregation levels on the rows from tree to tabular view. Note that Subtotals - see level members (All) - remains on the screen: this is a key difference with Tabular View.

If you need to hide intermediate levels in a multi-level hierarchy: switch to Display as Columns, click on column header and select "Remove", then switch back to Tree view, see "Display as Tree" below. Currently, Unhiding columns in a pivot table is only possible using the State Editor.

Display as Tree

To return to Tree view, right click on a column header and select "Display as Tree".

Hide and Show Content Editor

Depending on a particular implementation, the Content Editor may be displayed attached to the Pivot Table. Use the widget's action to show/hide the Content Editor if available.

Display KPI status

To display a KPI Status, drag it directly into the table:

Differences with a Tabular View

Differences between a Pivot Table and a Tabular View are summarized in this comparison table