Questions on Kendo UI for jQuery Forum

1 answer

20 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

54 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

0 answers

170 views

PivotGrid Custom measures for subtotal

Hi

I need create one measure for total sales amount Proportion by product category. For Example:

column measure

Productcate , Productname salesamount amount%

A, A1 100, 58%

A, A2 50 29%

A, A3 20 11%

A subtotal 170 73%

B, B1 50 83%

B, B2 10 17%

b subtotal 60 27%

Total 230 100%

How to design this code function?

Thanks.

James

PivotGrid

asked on 14 Sep 2023

1 answer

265 views

cdn.kendostatic.com vs kendo.cdn.telerik.com

I've never really paid attention to this but got curious when trying to debug something.

What's the difference between cdn.kendostatic.com and kendo.cdn.telerik.com?

In some Telerik documentation there are references to kendo.cdn.telerik.com. When I created a Telerik app in VS 2022, most references use cdn.kendostatic.com.

Should one be used over the other?

PivotGrid

answered on 18 Apr 2023

0 answers

119 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

258 views

Escaping special characters in Kendo PivotGrid for JQuery V1

Hi there,

Legacy PivotGrid does not support special characters in the column field headers (and possibly elsewhere), e.g. '&'. Is there a recommended escaping strategy - for example if I have a 'you & me' string, how do I transform it? and should I do it before datasource-ing the Pivot or in a header template?

(Looks like PivotGrid V2 does support this out of the box)

Thanks,
Georgi

PivotGrid

answered on 21 Dec 2022

1 answer

629 views

KendoUi Font icons are not loading

Actually we have kendoUi in angularjs project. which ic giving error in developer console like server not responding 404 error for webcomponentsicon.ttf and webcomponentsicon.woff. because of this icons are not loading. can anyone please help me to clear this issue

Hierarchical Data Source

answered on 15 Jun 2022

1 answer

440 views

Pivote Grid error: Uncaught TypeError: e.aggregate is not a function

I am attempting to locally run in my environment the code from the following demo:

https://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding

If I use the code functionally as-is it works fine. If however I change to an older version I receive the following error:

Uncaught TypeError: e.aggregate is not a function

My application is using version 2014.2.1008 which does provide the Pivot Grid even as it is a very old version. Is this a known issue resolved in a later version? Or perhaps I am just doing something wrong. Below is my code:

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8"/>
    <title>Pivot Grid Demo</title>
    <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2014.2.1008/styles/kendo.common.min.css" />
    <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2014.2.1008/styles/kendo.default.min.css" />
    <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2014.2.1008/styles/kendo.default.mobile.min.css" />
    <script src="http://kendo.cdn.telerik.com/2014.2.1008/js/jquery.min.js"></script>
    <script src="http://kendo.cdn.telerik.com/2014.2.1008/js/kendo.all.min.js"></script>
    <style>
        #configurator {
            width: 400px;
            min-width: 400px;
            display: inline-block;
            vertical-align: top;
        }

        #pivotgrid {
            width: 67%;
            display: inline-block;
            vertical-align: top;
        }
    </style>
</head>
<body>
    <script src="https://demos.telerik.com/kendo-ui/content/shared/js/products.js"></script>
	<div id="example">
	    <div class="hidden-on-narrow" id="configurator"></div>
	    <div class="hidden-on-narrow" id="pivotgrid"></div>
	
	    <div class="responsive-message"></div>
	
	    <script>
	        $(document).ready(function () {
	            var pivotgrid = $("#pivotgrid").kendoPivotGrid({
	                filterable: true,
	                sortable: true,
	                columnWidth: 120,
	                height: 570,
	                dataSource: {
	                    data: products,
	                    schema: {
	                        model: {
	                            fields: {
	                                ProductName: { type: "string" },
	                                UnitPrice: { type: "number" },
	                                UnitsInStock: { type: "number" },
	                                Discontinued: { type: "boolean" },
	                                CategoryName: { field: "Category.CategoryName" }
	                            }
	                        },
	                        cube: {
	                            dimensions: {
	                                ProductName: { caption: "All Products" },
	                                CategoryName: { caption: "All Categories" },
	                                Discontinued: { caption: "Discontinued" }
	                            },
	                            measures: {
	                                "Sum": { field: "UnitPrice", format: "{0:c}", aggregate: "sum" },
	                                "Average": { field: "UnitPrice", format: "{0:c}", aggregate: "average" }
	                            }
	                        }
	                    },
	                    columns: [{ name: "CategoryName", expand: true }, { name: "ProductName" } ],
	                    rows: [{ name: "Discontinued", expand: true }],
	                    measures: ["Sum"]
	                }
	            }).data("kendoPivotGrid");
	
	            $("#configurator").kendoPivotConfigurator({
	                dataSource: pivotgrid.dataSource,
	                filterable: true,
	                sortable:true,
	                height: 570
	            });
	        });
	    </script>
	</div>
</body>
</html>

PivotGrid

answered on 13 Oct 2021

1 answer

259 views

Pivot Grid, Column Values Populated When No Column Selected/Listed

I am currently working with the Pivot Grid; its quite nice. I have noticed though that if the Column is removed, the grid itself still retains data and formatting unique to that column. Using the demo as an example:
https://demos.telerik.com/jsp-ui/pivotgrid/index

The default columns are:

[Date].[Calendar] and [Product].[Category]

The default measure is:

[Measures].[Reseller Freight Cost]

If you remove all three of the above, both column fields and the measure, the resulting PivotGrid will still reflect a financial amount even though only a Row is populated with a Field.

See screen shot:

This is confusing to me and my users; why is it working this way? Is it possible to change this behavior?

PivotGrid

answered on 20 Sep 2021

1 answer

675 views

Pivot Grid Datasource, can JSON be used?

I'm struggling to get a Pivot Grid to populate. The demo works fine locally; however the datasource for it is XML from the datacube/dll. I have been using other widgets successfully with data delivered as JSON; is it possible to use JSON for the Pivot Grid? Are there any examples of this or even other examples of a Pivot Grid aside from the demo? Thanks in advance.

PivotGrid

answered on 02 Sep 2021