New to Kendo UI for jQuery? Download free 30-day trial

Expand Multiple Column Dimensions

You might need to reset the expanding that has occurred and revert to your CMS.

In order for the expand to properly work, set fully qualified names to the expanded tuples as shown in the following code snippet with the [Calendar Year].&[2005] configuration.

The following example demonstrates how to expand multiple column dimensions by using the dataBound event of the PivotGrid.

<div id="example">
    <div id="configurator"></div>
    <div id="pivotgrid"></div>

        $(document).ready(function () {
            var paths = [
              //Expand CY 2005 - first dimension
              ["[Date].[Calendar].[Calendar Year].&[2005]"],
              //Expand All Products under CY 2015 - second dimension
                ["[Date].[Calendar].[Calendar Year].&[2005]","[Product].[Category].[All Products]"]

            var pivotgrid = $("#pivotgrid").kendoPivotGrid({
                filterable: true,
                sortable: true,
                columnWidth: 200,
                height: 580,
                dataSource: {
                    type: "xmla",
                    columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Product].[Category]" } ],
                    rows: [{ name: "[Geography].[City]" }],
                    measures: ["[Measures].[Reseller Freight Cost]"],
                    transport: {
                        connection: {
                            catalog: "Adventure Works DW 2008R2",
                            cube: "Adventure Works"
                        read: ""
                    schema: {
                        type: "xmla"
                    error: function (e) {
                        alert("error: " + kendo.stringify(e.errors[0]));
                dataBound: function() {
                  var path = paths.shift();
                  if (path) {

See Also

In this article
Not finding the help you need? Improve this article