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

Remove the Total Column Summaries in the PivotGridV2


Product Progress® Kendo UI® PivotGrid for jQuery


How can I hide the Total column summaries in the jQuery PivotGridV2?


To achieve the desired scenario, use the dataBound event handler to target and hide the required elements.

<div id="pivotgrid"></div>
      $(document).ready(function () {
        var pivotgrid = $("#pivotgrid").kendoPivotGridV2({
          height: 550,
          dataSource: {
            type: "xmla",
            columns: [{ name: ['[Date].[Calendar]'], expand: true }],
            rows: [{ name: ['[Geography].[City]'], expand: true },
                   { name: ['[Product].[Category]'] }],
            measures: [{ name: ['[Measures].[Reseller Freight Cost]'] }],
            transport: {
              connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
              read: ''
          dataBound: function(e) {
            this.element.find(".k-pivotgrid-values .k-pivotgrid-tbody tr:last-child").hide();
            this.element.find(".k-pivotgrid-row-headers .k-pivotgrid-tbody tr:last-child").hide();

See Also

In this article