Adding a Pivot Table Row, Column, or Paging Filter Data Column

To add a new data column (row, column, or paging filter) to a pivot table portlet:

  1. Click Add Column.

    The Add Pivot Column dialog box opens.

  2. Provide the column details using the information from the following table.

  3. Field Name (*Required)

    Description

    *Column Title

    Specify the column title to display in the portlet. Type any alphanumeric string (up to 200 characters in length).

    *Data Source Column

    Select a source column for the information to display in the pivot table column.

    Dimension

    Select the dimension of the data. Choices include:

    • Add this column to the pivot rows dimension. Data is displayed one row per category. Categories are determined by the values from the data source.

    • Add this column to the pivot columns dimension. Data is displayed one column per category. Categories are determined by the values from the data source.

    • Add this column as a pivot paging filter. Data is displayed one table per category. Categories are determined by the values from the data source.

  4. Click Done.

    The Add Pivot Column dialog box closes and a new data column is added to the Create Portlet Definition (Pivot Table) page.