Showing and hiding highlighting and summaries 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 is displayed at the top of the table.

To enable and disable these options:

  1. Click the View Options button.

    A drop-down list of checkboxes is displayed. There are options for enabling and disabling the highlighting, the dimension summaries, and the table summaries.


    View Options menu on the Pivot Table component
  2. To show the value highlighting, check the Conditional Formatting checkbox.

    To hide the highlighting, uncheck the Conditional Formatting checkbox.

  3. To show the summaries for each dimension, check the Summaries checkbox.

    To hide the dimension summaries, uncheck the Summaries checkbox.

  4. To show the table summaries, which aggregate all of the values in a row or column, check the Grand Summary checkbox.

    To hide the table summaries, uncheck the Grand Summary checkbox.