PivotWindowDefinitionMode Enum

A window definition mode used to specify a window within the PivotDashboardItem.

Namespace: DevExpress.DashboardCommon

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

Declaration

public enum PivotWindowDefinitionMode
Public Enum PivotWindowDefinitionMode

Members

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.

Passed To

You can pass PivotWindowDefinitionMode values to the PivotWindowDefinition.DefinitionMode property.

Remarks

Values listed in this enumeration are used to set the PivotWindowDefinition.DefinitionMode property.

Examples

The code snippet adds a new measure to the Pivot dashboard item and specifies a window calculation to compute the difference between measure values across a window. The calculation is performed along columns of the Pivot dashboard item.

using DevExpress.DashboardCommon;
using DevExpress.DashboardWin;
// ...
PivotDashboardItem pivotItem = dashboardViewer1.Dashboard.Items[pivotItemName] as PivotDashboardItem;
if (pivotItem != null)
{
    Measure extendedPrice = new Measure("Extended Price")
    {
        Name = "Diff",
        ShowGrandTotals = false
    };
    PivotWindowDefinition pivotWindowDefinition = new PivotWindowDefinition();
    pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns;
    extendedPrice.WindowDefinition = pivotWindowDefinition;
    extendedPrice.Calculation = new DifferenceCalculation() { DifferenceType = DifferenceType.Absolute };
    pivotItem.Values.Add(extendedPrice);
}
See Also