I am use this example http://dojo.telerik.com/AZamu/2, with local binding I was modify to sort and filter and it don't work, this is my code:
<!DOCTYPE html>
<html>
<head>
<base href="http://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding">
<style>html { font-size: 12px; font-family: Arial, Helvetica, sans-serif; }</style>
<title></title>
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.common.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.default.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.dataviz.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.dataviz.default.min.css" />
<script src="http://cdn.kendostatic.com/2014.3.1411/js/jquery.min.js"></script>
<script src="http://cdn.kendostatic.com/2014.3.1411/js/kendo.all.min.js"></script>
</head>
<body>
<script src="../content/shared/js/products.js"></script>
<div id="example">
<div id="configurator"></div>
<div id="pivotgrid"></div>
<script>
$(document).ready(function () {
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
columnWidth: 120,
height: 570,
filterable: true,
sortable: true,
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,
height: 570
});
});
</script>
<style>
#pivotgrid
{
display: inline-block;
vertical-align: top;
width: 70%;
}
#configurator
{
display: inline-block;
vertical-align: top;
}
</style>
</div>
</body>
</html>
Why It don't work wiht local bind?
Thanks.
10 Answers, 1 is accepted
Currently, the client PivotGrid Cube supports only drill-down functionality. Sorting and filtering are not supported for the time being. They are in our TODO list, but I cannot provide any specific time frame whether they will be available.
Regards,
Georgi Krustev
Telerik
Rank 1
Hi,
Just wanted to do a quick check if this works now in the latest version. If yes, how as I am unable to make sorting work in PivotGrid.
Thanks,
Anand
The client PivotGrid cube supports drill-down and filtering functionality. Label sorting is still not available. It is in our plans to provide support for it, but I wouldn't be able to provide any specific time frame for that.
Regards,
Georgi Krustev
Telerik by Progress
Rank 1
Hello Georgi,
Any update with sorting functionality? I have this same problem like Anand, its going to be urgent ;)
Regards
Łukasz
Unfortunately, the Kendo UI PivotGrid does not have a sorting implementation at present. Our priorities shifted and we never got round to the client cube sort. I could give you some guidance, however, please be advised that we cannot guarantee the results. Behind the scene, we loop over the flat data and the dimensions consecutively (this is the relation columns <---> dimensions). So if you sort the data by dimensions in advance, there is a good chance to generate a pivot sorted by columns and by rows.
There are some alternative solutions to get the Kendo UI PivotGrid sorted that you may read about on the web. They require the creation of a .cub file which can then be used as OLAP. I don't know if they will be fit for your purpose, it is beyond my expertise, however, I thought I would share this with you nonetheless:
https://support.office.com/en-us/article/Work-with-offline-cube-files-a1014690-efb7-480d-b717-308a39063235
https://www.mrexcel.com/forum/excel-questions/33837-i-want-create-cub-file-excel.html
Kind Regards,
Alex Hajigeorgieva
Telerik by Progress
Rank 1
Hi Alex,
Thanks for Your response. W tried before to sort data in advance. Success is partial. Not all dimension will be sorted this method because of aggregations (one dimension gather other detailed - you need decide which one should be sorted). I was considering switch to Microsoft OLAP but our customer is not ready for additional costs for now.
If something will change in your roadmap please let me know.
Regards
Lukasz
Hello,
Also I would suggest to keep eye on our Release History.
Regards,Boyan Dimitrov
Telerik by Progress
Rank 1
Hello,
Any update with sorting functionality? I have this same problem.
I just read all the release history but i don't see this functionality.
Regards
I am afraid that the Kendo UI PivotGrid is not in high demand and the implementation of the sorting functionality of the client cube is not in our immediate plans. I had a look at the UserVoice forum where our clients vote for new features and the item is not very popular there:
http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/18180664-add-sorting-to-kendo-ui-pivotgrid
In such cases is better to look at the alternative solutions I mentioned in an earlier post of mine:
https://www.telerik.com/forums/local-bind-and-filter-or-sort-do-work#x1uZqoFMKE6DlJSR-NGAUg
Kind Regards,
Alex Hajigeorgieva
Progress Telerik
Hello,
I am pleased to let you know that sorting by column and row headers with flat data is now implemented as of 2020 R3 release. You can take a look at the online demo:
https://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding
You can enable the sortable options in the field menu by adding sortable:true to the configuration options:
https://docs.telerik.com/kendo-ui/api/javascript/ui/pivotgrid/configuration/sortable
Regards,
Alex Hajigeorgieva
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.