dxPivotGrid
Namespace: Wisej.Web.Ext.DevExtreme
Assembly: Wisej.Web.Ext.DevExtreme (4.1.0.0)
The PivotGrid is a widget that allows you to display and analyze multi-dimensional data from a local storage or an OLAP cube.
- C#
- VB.NET
public class dxPivotGrid : dxBase
Public Class dxPivotGrid
Inherits dxBase
Constructors
dxPivotGrid()
Constructs a new instance of the dxPivotGrid class.
Example:
The following example creates a pivot grid that summarizes a list of sales by region and year.
var pivot = new dxPivotGrid();
pivot.Options.dataSource = new
{
store = sales,
fields = new object[]
{
new { dataField = "region", area = "row" },
new { dataField = "year", area = "column" },
new { dataField = "amount", area = "data", summaryType = "sum", dataType = "number" }
}
};
pivot.Options.showBorders = true;
pivot.Dock = DockStyle.Fill;
this.Controls.Add(pivot);
dxPivotGrid(options)
Constructs a new instance of the dxPivotGrid class.
| Name | Type | Description |
|---|---|---|
| options | Object | Initial set of options. |
Example:
The following example creates a pivot grid with a field chooser that lets the user sort and filter the fields.
var pivot = new dxPivotGrid(new
{
allowSorting = true,
allowFiltering = true,
fieldChooser = new { enabled = true },
dataSource = new
{
store = orders,
fields = new object[]
{
new { dataField = "category", area = "row" },
new { dataField = "country", area = "column" },
new { dataField = "total", area = "data", summaryType = "sum", format = "currency" }
}
}
});
pivot.Dock = DockStyle.Fill;
this.Controls.Add(pivot);