0

`Need some example which can help me to bind data into MVC kendo Pivot Grid2. I have to display data in Kendo PIvot grid 2 in MVC.

I tried to display data in kendo Pivot Grid2 in MVC. I want to read data from MVC action method and bind to Kendo Grid 2.

<div id="example">
@(Html.Kendo().PivotContainer()
    .Name("container")
    .ConfiguratorPosition("left")
    .Content(@<text>
        @(Html.Kendo().PivotConfiguratorV2()
            .Name("configurator")
            .Sortable(true)
            .Filterable(true))
        @(Html.Kendo().PivotGridV2()
            .Name("pivotgrid")
            .ColumnWidth(200)
            .Height(580)
            .Configurator("#configurator")
            .DataSource(dataSource => dataSource.
                Xmla()
                .Columns(columns => {
                    columns.Add("[Date].[Calendar]").Expand(true);
                    columns.Add("[Product].[Category]");
                })
                .Rows(rows => rows.Add("[Geography].[City]").Expand(true))
                .Measures(measures => measures.Values(new string[]{"[Measures].[Reseller Freight      Cost]"}))
                .Transport(transport => transport
                    .Connection(connection => connection
                        .Catalog("Adventure Works DW 2008R2")
                        .Cube("Adventure Works"))
                    .Read("https://demos.telerik.com/olap/msmdpump.dll")
                )
            )
        )
        @(Html.Kendo().PivotConfiguratorButton()
            .Name("Button")
            .Configurator("configurator")
        )
</text>))
</div>

Need to display output as below. enter image description here

0 Answers0