Selecting the source of the Pivot Table data

On the Data Selection tab of the Pivot Table edit view, you select the view to use for the Pivot Table data. You also configure the maximum number of cells to display.

For information on selecting the view to use for a component, see Selecting the view to use for a component.

To configure the maximum number of cells to display:

  1. In the Maximum number of cells to display field, type the maximum number of cells that can be displayed.

    Max records field on the Pivot Table Data Configuration tab of the Pivot Table component

    If the number of cells is greater than this number, then the Pivot Table displays an error. End users can then refine the data to try to reduce the number of cells.

    The default maximum is 3000 cells.

  2. In the Maximum number of cells exceeded message field, type the error message to display to end users when the number of cells for the current data is greater than the maximum allowed.
    In the message text, you can use the following dynamic values:
    • {cells} - The number of cells in the Pivot table.
    • {limit} - The value of the Maximum number of cells to display field.