Pivot Options

To display this screen:

1. Display a pivot table and activate the Home ribbon.

2. Select Pivot Table >> Options.

This screen is used to configure a pivot table view, and is split into two parts:

• On the left, the pivot tables of your project are listed. You can add, delete and edit pivot tables here. See Create a Pivot Chart.

• On the right, there are tabs containing categorized groups of commands:

  • General – Decide which data is shown on your pivot table (row total, grand total, domain function and so on). See Pivot Options: General.

  • Row Area – Decide how row data is presented (which field(s) and in which format(s). See Pivot Options: Row Area.

  • Column Area – Configure the pivot table column presentation. See Pivot Options: Column Area.

  • Data Area – Format the cells in the main body of pivot table data, and apply filtering. See Pivot Options: Data Area.