corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsdata-dot-underscore-properties.md
Provides data specific options for PivotGrid controls.
| Name | Description |
|---|---|
| AllowCrossGroupVariation | Gets or sets whether summary variations and running totals are calculated independently within individual groups, or throughout the Pivot Grid. |
| AutoExpandGroups | Gets or sets whether field values are expanded or collapsed by default. |
| CaseSensitive | Gets or sets whether data is grouped case-sensitively. |
| CustomObjectConverter | Gets or sets a converter used to serialize/deserialize arbitrary objects in a custom manner. |
| DataFieldUnboundExpressionMode | Gets or sets whether unbound expressions for pivot grid’s data fields are calculated based on the data source records or summary values. |
| DataProcessingEngine | Gets or sets the engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid. |
| DirectDataAccessInClientMode | Gets or sets whether the calculation engine bypasses the creation of temporary storage for source data. |
| DrillDownMaxRowCount | Gets or sets the maximum number of rows returned when obtaining underlying data. |
| FilterByVisibleFieldsOnly | Gets or sets whether to take into account filter conditions of visible filter fields only. |
| OptimizeSummaryTypeCalculation | Gets or sets whether to use decimal type conversion while calculating data in certain aggregation types. |
| RetrieveNestedFields | Gets or sets whether to add nested fields when retrieving fields from the bound data source. |
| UseDataBindingAPI |
See Also