ASP.NET MVC PivotGrid Overview

Telerik UI for ASP.NET MVC Ninja image

The PivotGrid is part of Telerik UI for ASP.NET MVC, a professional grade UI library with 110+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.

The Telerik UI PivotGrid HtmlHelper for ASP.NET MVC is a server-side wrapper for the Kendo UI PivotGrid widget.

The PivotGrid represents multidimensional data in a cross-tabular format.

Basic Configuration

To configure the PivotGrid for Ajax binding to an Adventure Works cube that is hosted on

  1. Create a new ASP.NET MVC application. If you have the Telerik UI for ASP.NET MVC Visual Studio Extensions installed, create a Telerik UI for ASP.NET MVC application. Name the application KendoPivotGrid. If you decide not to use the Telerik UI for ASP.NET MVC Visual Studio Extensions, follow the steps from the introductory article to add Telerik UI for ASP.NET MVC to the application.
  2. Add a PivotGrid to the Index view.
        .DataSource(dataSource => dataSource.
            .Columns(columns => {
            .Rows(rows => rows.Add("[Product].[Product]"))
            .Measures(measures => measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
            .Transport(transport => transport
                .Connection(connection => connection
                    .Catalog("Adventure Works DW 2008R2")
                    .Cube("Adventure Works"))
                .Read(read => read
  1. Build and run the application.

Functionality and Features

Referencing Existing Instances

To reference an existing PivotGrid instance, use the method. Once a reference is established, use the PivotGrid client-side API to control its behavior.

var pivotgrid = $("#pivotgrid").data("kendoPivotGrid");

See Also

In this article