PivotWindowDefinition.DefinitionMode Property

Gets or sets the window definition mode used to perform calculations within the PivotDashboardItem.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v18.2.Core.dll

Declaration

C#

[DefaultValue(PivotWindowDefinitionMode.Columns)]
public PivotWindowDefinitionMode DefinitionMode { get; set; }

VB.NET

<DefaultValue(PivotWindowDefinitionMode.Columns)>
Public Property DefinitionMode As PivotWindowDefinitionMode

Property Value

Type	Default	Description
PivotWindowDefinitionMode	**Columns**	A PivotWindowDefinitionMode enumeration value that specifies the window definition mode.

Available values:

Name	Description
Columns	A calculation is performed horizontally through Pivot columns.
Rows	A calculation is performed vertically through Pivot rows.
ColumnsAndRows	A calculation is performed horizontally through Pivot columns, then rows.
RowsAndColumns	A calculation is performed vertically through Pivot rows, then columns.
GroupsInColumns	A calculation is performed horizontally through Pivot columns within groups.
GroupsInRows	A calculation is performed vertically through Pivot rows within groups.
GroupsInColumnsAndRows	A calculation is performed horizontally through Pivot columns, then rows within groups.
GroupsInRowsAndColumns	A calculation is performed vertically through Pivot rows, then columns within groups.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the DefinitionMode 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.

C#

winforms-dashboard-window-calculation-example/CS/WindowCalculationExample/Form1.cs#L45

PivotWindowDefinition pivotWindowDefinition = new PivotWindowDefinition();
pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns;
extendedPrice.WindowDefinition = pivotWindowDefinition;

VB.NET

winforms-dashboard-window-calculation-example/VB/WindowCalculationExample/Form1.vb#L36

Dim pivotWindowDefinition As PivotWindowDefinition = New PivotWindowDefinition()
pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns
extendedPrice.WindowDefinition = pivotWindowDefinition