Local Bind and filter or sort don't work

4 posts, 1 answers
  1. Gus
    Gus avatar
    29 posts
    Member since:
    Jan 2015

    Posted 15 Feb 2015 Link to this post


    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>
        <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>
        <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>
    <script src="../content/shared/js/products.js"></script>

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

            $(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"]

                    dataSource: pivotgrid.dataSource,
                    height: 570
                display: inline-block;
                vertical-align: top;
                width: 70%;

                display: inline-block;
                vertical-align: top;


    Why It don't work wiht local bind?


  2. Answer
    Georgi Krustev
    Georgi Krustev avatar
    3717 posts

    Posted 16 Feb 2015 Link to this post

    Hello Gustavo,

    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.

    Georgi Krustev
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
  3. Anand
    Anand avatar
    1 posts
    Member since:
    Apr 2016

    Posted 31 Jan Link to this post


    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.



  4. Georgi Krustev
    Georgi Krustev avatar
    3717 posts

    Posted 01 Feb Link to this post

    Hello 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.

    Georgi Krustev
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top