corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridfieldbase-d72dac19.md
Gets or sets how the specified data field’s unbound expression is calculated.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(UnboundExpressionMode.Default)]
public UnboundExpressionMode UnboundExpressionMode { get; set; }
<DefaultValue(UnboundExpressionMode.Default)>
Public Property UnboundExpressionMode As UnboundExpressionMode
| Type | Default | Description |
|---|---|---|
| UnboundExpressionMode | Default |
An UnboundExpressionMode object that specifies how the specified data field’s unbound expression is calculated.
|
Available values:
| Name | Description |
|---|---|
| Default |
The default parameter value.
| | UseSummaryValues |
An unbound expression is calculated against summary values.
| | DataSource |
An unbound expression is calculated against each data source record, and then the resulting values are summarized.
| | UseAggregateFunctions |
An unbound expression is calculated using aggregates.
|
Note
This member is not supported in Optimized, OLAP, and Server modes. Use ExpressionDataBinding/OlAPExpressionBinding instead.
By default, the unbound expression is calculated against each data source record, and then the resulting values are summarized. If necessary, you can calculate unbound field values on the visualization (or summary) level. You can also use a specified set of summary functions (such as Sum, Avg, etc.) to summarize data source records. The UnboundExpressionMode property allows you to specify the mode used to calculate unbound field values.
To learn more, see Unbound Fields.
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the UnboundExpressionMode property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
fieldValueTotal.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
fieldValueTotal.UnboundExpressionMode = UnboundExpressionMode.UseAggregateFunctions;
}
fieldValueTotal.UnboundType = DevExpress.Data.UnboundColumnType.Decimal
fieldValueTotal.UnboundExpressionMode = UnboundExpressionMode.UseAggregateFunctions
End Sub
See Also