`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