XRPivotGridOptionsData Properties

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