aspnetcore-400790-devextreme-based-controls-controls-pivot-grid.md
Pivot Grid is a UI control that allows you to display and analyze multi-dimensional data.
Run Demo: Pivot Grid Read Tutorial
The Pivot Grid UI Control is based on the DevExtreme Pivot Grid component.
To add this control to your project, follow instructions in the following help topics:
@(Html.DevExtreme().PivotGrid()
.DataSource(dataSource => dataSource
.Store(store => store.Xmla()
.Url("https://demos.devexpress.com/Services/OLAP/msmdpump.dll")
.Catalog("Adventure Works DW Standard Edition")
.Cube("Adventure Works")
)
.Fields(fields => {
fields.Add()
.DataField("[Product].[Category]")
.Area(PivotGridArea.Row);
fields.Add()
.DataField("[Product].[Subcategory]")
.Area(PivotGridArea.Row);
fields.Add()
.DataField("[Ship Date].[Calendar Year]")
.Area(PivotGridArea.Column);
fields.Add()
.DataField("[Ship Date].[Month of Year]")
.Area(PivotGridArea.Column);
fields.Add()
.DataField("[Measures].[Reseller Freight Cost]")
.Area(PivotGridArea.Data);
})
)
)
using Microsoft.AspNetCore.Mvc;
namespace ASP.NET_Core.Controllers {
public class PivotGridController : Controller {
public IActionResult GettingStarted() {
return View();
}
}
}
Data Binding
Pivot Grid can display data from various sources: an in-memory array, HTML5 web storage, OData service, OLAP server, or a customized data source. To process data from the source, use PivotGridDataSource.
Summary Calculation Modes
Pivot Grid displays value summaries (totals) in its cells. Choose between predefined summaries, aggregate values, or a implement a custom summary. Pivot Grid can also calculate running totals by rows or columns.
Customizable Layout
Pivot Grid allows you to customize its layout. You can enable or disable multiple Pivot Grid elements. Review the Visual Elements article for more information.
Grouping, Sorting, and Filtering
Pivot Grid groups data for header items and fields. Sort or filter fields through the UI or programmatically.
Export to Excel
Export Pivot Grid data to Excel in XLSX or CSV format and customize the exported cells.
Chart Integration
Pivot Grid handles large numeric datasets that can be hard to interpret. For a detailed data visualization, use the Chart component that integrates into Pivot Grid.
Virtual Scrolling
If Pivot Grid is bound to a large dataset, you can enable a virtual scrolling mode to optimize data load time and reduce resource consumption.
Drill Down
Pivot Grid supports drill-down operations that allow you to retrieve individual records for calculating a specific summary value.
InitializationCall the PivotGrid() method to create a Pivot Grid control. This action initializes a PivotGridBuilder<T> instance. Use the instance methods to specify Pivot Grid options and event handlers.OptionsFor a complete option list, see Options. For details on how to specify control options, refer to the following help topic: Specify Options.EventsFor available events, see Events. For details on how to handle events, refer to the following help topic: Handle Events and Define Callbacks.
OptionsIf you need to specify the Pivot Grid options dynamically on the client side, use client-side API. For a complete option list, see DevExtreme Pivot Grid options.MethodsFor a list of available methods, see DevExtreme Pivot Grid methods. For details on how to call methods, refer to the following help topic: Call Methods.
See Also