Questions on Kendo UI for jQuery Forum

1 answer

6 views

Kendo jQuery PivotGrid: Show hierarchy levels in Fields

I want to compare two data types side-by-side in one PivotGrid. Conceptually the Fields tree should look like:

Field

DATA 0
├─ Area Data 0
└─ Period Data 0

DATA 1
├─ Area Data 1
└─ Period Data 1

Measures
• Value Data 0
• Value Data 1

Then on Columns I’d place Area → Period under DATA 0 (and/or DATA 1) to get a hierarchical header.

Question

Is showing expandable hierarchy levels in the Fields panel supported with client-side data?
If yes, what’s the correct schema?
If not, what’s the recommended approach (e.g., model each level as its own dimension), and would PivotGrid v2 change this?

Product & version

Kendo UI for jQuery – PivotGrid (classic, not v2)
Reproduced on CDN builds 2023.2.718 and 2024.2.514
Browser: Chrome (latest)

PivotGrid

PivotGridV2

answered on 19 Aug 2025

1 answer

34 views

Pivotgridv2 measure is not slicing the data by the second attribute when expanding

When there is a second item in a row and both are expanded the value is no longer sliced(filtered?) by the first item. My users are used to this with excel etc and really want this functionality how can I achieve it?

Value sum is correct (sliced) for all rows

where second row is expanded and not correct(sliced?).

Here is a simplified version of my code showing the unwanted behavior

<!DOCTYPE html>
<html lang="en">
<head>
  <link href="../content/shared/styles/examples-offline.css" rel="stylesheet">
  <link href="../../styles/default-ocean-blue.css" rel="stylesheet">
  <script src="https://code.jquery.com/jquery-3.7.0.min.js"></script>
  <script src="https://unpkg.com/jszip/dist/jszip.min.js"></script>
  <script src="../../js/kendo.all.min.js"></script>
  <script src="../content/shared/js/console.js"></script>
</head>
<body>
  <div id="container">
    <div id="pivotgrid"></div>
    <div id="configurator"></div>
    <div id="pivotbutton"></div>
  </div>
  <script>
    var dataSource = new kendo.data.PivotDataSourceV2({
      "data": [
        { "Value": 77, "ASort": 2, "BSort": "b" },
        { "Value": 28, "ASort": 1, "BSort": "a" },
        { "Value": 63, "ASort": 2, "BSort": "a" },
        { "Value": 42, "ASort": 1, "BSort": "b" }
      ],
      rows: [
        { name: "ASort", expand: true },
        { name: "BSort", expand: true }
      ],
      "schema": {
        "model": {
          "fields": {
            "Value": { "type": "number" },
            "ASort": { "type": "number" },
            "BSort": { "type": "string" }
          }
        },
        "cube": {
          "dimensions": {
            "ASort": { "caption": "ASort" },
            "BSort": { "caption": "BSort" }
          },
          "measures": {
            "Value sum": {
              "field": "Value",
              "format": "{0:n}",
              "aggregate": "sum"
            }
          }
        }
      }
    });


    $(document).ready(function () {
      window.pivotgrid = $("#pivotgrid").kendoPivotGridV2({
        height: $(window).height() - 2,
        dataSource: dataSource

      }).data("kendoPivotGridV2");

      $("#configurator").kendoPivotConfiguratorV2({
        dataSource: pivotgrid.dataSource,
        filterable: true,
        sortable: true
      });

      $("#pivotbutton").kendoPivotConfiguratorButton({
        configurator: "configurator"
      });

      $("#container").kendoPivotContainer({
        configuratorPosition: "left"
      });
    });
  </script>

</body>
</html>

Data Source

PivotGridV2

answered on 15 May 2025

1 answer

50 views

Is there support for equivalent of RowTableLayout=Compact ?

Hi,

I can see that the PivotGrid has a "Compact" display mode in the ASP.NET AJAX libraries: https://docs.telerik.com/devtools/aspnet-ajax/controls/pivotgrid/layouts/overview

Is there a "Compact" mode that renders nested rows with only a slight offset instead of creating a whole new column in the jQuery libraries, or even in ASP.NET MVC version?

Kind regards,
Ilya

PivotGrid

PivotGridV2

answered on 18 Jul 2024

1 answer

120 views

PivotGridV2 JSON Remote data binding

Hello everyone,

I am using PivotGridV2. I want to work with Remote Data. In the examples I have examined, the calls are made using XMLA or OData. How can I adapt the pivotGridV2 component using a JSON service?

Thanks.

PivotGridV2

answered on 11 Jun 2024

1 answer

89 views

PivotGridV2 Local Binding cannot to change measure name

Hi

I used the PivotGridV2 from Local Binding of data source. I want to change the measure name at demo sample, for example: Sum change to Sumass, than I found error from browser for "format error". How to change the measure name of local binding data source?

measures: {
"Sumass": { field: "Revenue", format: "{0:c}", aggregate: "sum"},
"Average": { field: "Revenue", format: "{0:c}", aggregate: "average" }
}
}
},
columns: [{ name: "Year", expand: true }, { name: "Sector" } ],
rows: [{ name: "Country", expand: true }],
measures: ["Sumass", "Average"]

James

PivotGridV2

answered on 04 Sep 2023

0 answers

115 views

Kendo Pivotgrid

Hi,

How can I apply xmla data from asp.net core api to kendo pivotgrid using jquery.

So I created an endpoint that returns xmla data. just having a problem binding the data to the pivotgrid.

PivotGrid

PivotGridV2

asked on 12 Apr 2023

1 answer

272 views

Display month name in column header

Hi I am using PivotGrid V2 and binding to local data ( json array ), the data contain a field called CompletedDate ( format 16/4/2022 18:00), what I would like to do is create a pivot grid that contain the month name columns as below, is this possible

		Year: 2022
		Jan	Feb	March	April	May	June	July	Aug	Sep	Oct	Dec
Status	Reviewed	1	4	1	9	33	4	5	26	5	22	33	134
	Awating Review	3	6	6	1	1	1	1	1	1	1	1	23
		4	10	1	1	34	5	6	27	6	23	34	151

Thanks

PivotGridV2

answered on 11 Jan 2023

0 answers

124 views

Count aggregates missing

Hi I cannot find a 'Count' aggregate in the new Pivot grid , the previous version did have it ?

Also will there be support to provide a 'Percentage' measure

Thanks

PivotGridV2

asked on 06 Jan 2023

1 answer

251 views

Problems in Kendo PivotGrid for JQuery V2

Hi there,

We face a few filter-related issues when exploring Pivot grid V2 and using the default configuration options.

1. When Kendo pivotGridconfiguratorV2 is not displayed we miss the opportunity to apply filters (that works in the legacy Pivot grid). Can you suggest a workaround or a config option?

2. When a filter is programmatically applied and the configurator is displayed, in the respective field dropdown this is still not reflected (prefilled), so the user wouldn't know a filter is already acting. That also works in the legacy Pivot.

3. For certain field types (e.g. number) the option to apply field filter is not provided at all, even when we have one programmatically applied already, only 'Include fields...'