Pivot Options
To display this screen:
-
Display a pivot table and activate the Home ribbon.
-
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 table layouts 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.
-
