Pivot Table Portlet

Figure 3-5. Set up Display Options for pivot table portlets

Table 3-2. Set up Display Options field descriptions for pivot table portlets

Field Name (*Required)

Description

Dimension section

Add Column

Click to add a new data column. See Adding a Pivot Table Row, Column, or Paging Filter Data Column for details.

Add Measurement

Click to add a new measurement data column. See Adding a Pivot Table Measurement Data Column for details.

Edit

Select a data column, then click to make changes to that data column. You can also double-click on a specific data column to edit that data column.

Delete

Select a data column, then click to remove that column.

Data columns displayed in the pivot row dimension

Use the up- and down-pointers to rearrange the order of the data columns. Double-click on a data column to edit it.

This data is displayed one row per category.

Data columns displayed in the pivot column dimension

Use the up- and down-pointers to rearrange the order of the data columns. Double-click on a data column to edit it.

This data is displayed one column per category.

Data columns used as pivot paging filters

Use the up- and down-pointers to rearrange the order of the data columns. Double-click on a data column to edit it.

This data is displayed one table per category.

Data columns used as pivot measurements

Use the up- and down-pointers to rearrange the order of the data columns. Double-click on a data column to edit it.

This is the data that is summarized in the table.

Display Options section

Enable aggregation configuration

By default, aggregation is enabled.

Aggregation configuration is the calculation of values based on the selected Totals aggregation function.

Disable aggregation if the data source aggregates the data.

Aggregation function

Select a function to determine how to calculate a value if the data source contains more than one value for a distinct data column.

Display empty cells

If the data source does not contain any data, the row or column is not displayed. Select this checkbox to display empty cells.

Totals aggregation function

Select a function to determine how to calculate the totals for the displayed values.

Display row/column totals

Select to display totals for all rows and columns. The value is calculated using the selected Totals aggregation function.

Display subtotals

Select to display subtotals for each row or column. The value is calculated using the selected Totals aggregation function.

Hyperlink Options

Specify whether the column can be linked to another page or portlet, or updates the other portlets on this page.

Choices include: