Configuring display options for the Pivot Table

The Display Options tab of the Pivot Table edit view contains options for setting size and other display options for the Pivot Table table.

To configure the Pivot Table display options:

  1. Under Table height, in the field, type the number of rows that are visible at a time.
  2. In the Column width field, type the width in pixels to use for each column.
  3. Under Grid display, to hide any empty rows or columns, check the Hide empty rows/columns checkbox.
  4. Under Summaries, use the checkboxes to indicate whether to display the summary and grand summary rows by default.