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

Change the Field Names of the PivotGrid


Product Progress® Kendo UI® PivotGrid for jQuery
Operating System Windows 10 64bit
Visual Studio Version Visual Studio 2017
Preferred Language JavaScript


How can I modify and control the content that is rendered by the field names of the Kendo UI PivotGrid widget?


The following example demonstrates how to change the text displayed by the [Date].[Calendar] and [Product].[Category] fields in a PivotGrid.

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

        $(document).ready(function () {
            var pivotgrid = $("#pivotgrid").kendoPivotGrid({
                filterable: true,
                columnWidth: 200,
                height: 580,
                dataBound: function() {                          
                  var fields = this.columnFields.add(this.rowFields).add(this.measureFields);

                    .each(function(_, item) {
                        item = $(item);
                        var text ="name").split(".").slice(-1) + "";

                dataSource: {
                    type: "xmla",
                    columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Product].[Category]" } ],
                    rows: [{ name: "[Geography].[City]" }],
                    measures: ["[Measures].[Internet Sales Amount]"],
                    transport: {
                        connection: {
                            catalog: "Adventure Works DW 2008R2",
                            cube: "Adventure Works"
                        read: ""
                    schema: {
                        type: "xmla"
                    error: function (e) {
                        alert("error: " + kendo.stringify(e.errors[0]));
            display: inline-block;
            vertical-align: top;
            width: 70%;

See Also

In this article