measures.axis String (default: columns)

The name of the axis on which the measures will be displayed. The supported values are the rows or columns. This option is applicable if multiple measures are used.

Example - set the axis of the measures

<div id="pivot"></div>

<script>
var dataSource = new kendo.data.PivotDataSourceV2({
  type: "xmla",
  measures: {
      values: ["[Measures].[Internet Revenue Trend]", "[Measures].[Internet Revenue Status]"],
      axis: "rows"
  },
  transport: {
    connection: {
        catalog: "Adventure Works DW 2008R2",
        cube: "Adventure Works"
    },
    read: "https://demos.telerik.com/olap/msmdpump.dll"
  }
});

$("#pivot").kendoPivotGridV2({
  dataSource: dataSource
});
</script>
In this article