Displaying summaries and highlighting in the Pivot Table

The Pivot Table component can include summaries of individual row or column dimensions as well as summary rows and columns for the entire table. Individual values may also be highlighted. The Pivot Table may be configured to allow you to show or hide the summaries, and to show or hide the highlighting

If you can control these features, then a View Options button displays at the top of the table.

To enable and disable these options:

  1. Click View Options.

    A list of check boxes displays. There are options for enabling and disabling the highlighting, the dimension summaries, and the table summaries.

  2. To show or hide the value highlighting, select or deselect the Conditional Formatting check box.
  3. To show or hide the summaries for each dimension, select or deselect the Summaries check box.
  4. To show or hide the table summaries, which aggregate all of the values in a row or column, select or deselect the Grand Summary check box.