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

ExpandColumn

methods

Expands a column tuple member that has children.

The path has to include the unique member names until the significant (the one that needs to be expanded) member is reached.

expandColumn

Parameters:pathArray

The path that uniquely specifies the tuple member that needs to be expanded.

<!-- Real life demo: https://docs.telerik.com/kendo-ui/web/pivotgrid/how-to/expand-multiple-dimensions -->

<script>
var dataSource = new kendo.data.PivotDataSource({
  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"
    },
    read: "https://demos.telerik.com/service/v2/olap/msmdpump.dll"
  },
  schema: {
    type: "xmla"
  }
});

dataSource.one("dataBound", function() {
    //Expand CY 2005 - first dimension
    dataSource.expandColumn(["[Date].[Calendar].[Calendar Year].&[2005]"]);

    //Expand All Products under CY 2015 - second dimension
    dataSource.expandColumn(["[Date].[Calendar].[Calendar Year].&[2005]","[Product].[Category].[All Products]"]);
});

dataSource.read();
</script>