Pivot Grid

• Mar 24, 2026
• 3 minutes to read

Pivot Grid is a UI control that allows you to display and analyze multi-dimensional data.

Run Demo: Pivot Grid Read Tutorial

Getting Started

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:

• Configure a Visual Studio Project or Configure a non Visual Studio Project
• Add Controls to a Project
• Razor Syntax

Basic Syntax

PivotGridBasics.cshtml

@(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);
        })
    )
)

PivotGridController.cs

using Microsoft.AspNetCore.Mvc;

namespace ASP.NET_Core.Controllers {
    public class PivotGridController : Controller {
        public IActionResult GettingStarted() {
            return View();
        }
    }
}

Built-in Capabilities and Configuration Guides

• 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.

API

Server-Side API

Initialization

Call 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.

Options

For a complete option list, see Options. For details on how to specify control options, refer to the following help topic: Specify Options.

Events

For available events, see Events. For details on how to handle events, refer to the following help topic: Handle Events and Define Callbacks.

Client-Side API

Options

If 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.

Methods

For 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.

Demos

Run Demo: Pivot Grid