dataCellTemplate String|Function

The template which renders the content of the data cell. By default renders the formatted value (fmtValue) of the data item.

The fields which can be used in the template are:

  • columnTuple - the tuple of the corresponding column header cell
  • rowTuple - the tuple of the corresponding row header cell
  • measure - the value of the data cell measure
  • dataItem - the data item itself

For information about the tuple structure check this link. About the data item structure review this help topic.

Example - bold the value for the 2010 column and use the formatted value for the other columns.

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

<script id="dataCellTemplate" type="text/x-kendo-template">
    # if (columnTuple.members[0].name === "[Date].[Calendar].[Calendar Year].&[2010]") { #
            <!-- Display the value in bold for the year 2010. -->
        <b>#: dataItem.value #</b>
    # } else { #
            <!-- Display the formatted value for the other years. -->
        #: dataItem.fmtValue #
    # } #
</script>

<script>
$("#pivotgrid").kendoPivotGrid({
    dataCellTemplate: $("#dataCellTemplate").html(),
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true } ],
        measures: ["[Measures].[Internet Sales Amount]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>
In this article