Grid Options

Use the Grid Options section to define Pivot Grid view options for the grid and the chart.

This example illustrates the fields and controls in the Specify Data Model Options page - Grid Options section. Definitions for the fields and controls appear following the example.

Grid Options section
Field or Control Description

Collapsible Data Area

Select to allow viewers to collapse the data area.

Expanded State

Select to have the initial view expanded.

No Drag and Drop

Select if you do not want users to have the ability to drag and drop filters, rows, and column axes.