This is a migrated thread and some comments may be shown as answers.

Local Bind and filter or sort don't work

10 Answers 303 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Gus
Top achievements
Rank 2
Gus asked on 15 Feb 2015, 06:29 PM
hello,

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

Sort by
0
Accepted
Georgi Krustev
Telerik team
answered on 16 Feb 2015, 12:32 PM
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.

Regards,
Georgi Krustev
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Anand
Top achievements
Rank 1
answered on 31 Jan 2017, 06:50 PM

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

0
Georgi Krustev
Telerik team
answered on 01 Feb 2017, 08:43 AM
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.

Regards,
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.
0
Łukasz
Top achievements
Rank 1
answered on 05 Apr 2017, 04:25 AM

Hello Georgi,

Any update with sorting functionality? I have this same problem like Anand, its going to be urgent ;)

Regards

Łukasz

0
Alex Hajigeorgieva
Telerik team
answered on 06 Apr 2017, 12:56 PM
Hello Ł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
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 (charts) and form elements.
0
Łukasz
Top achievements
Rank 1
answered on 11 Apr 2017, 04:18 PM

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

 

0
Boyan Dimitrov
Telerik team
answered on 13 Apr 2017, 11:48 AM

Hello,

Also I would suggest to keep eye on our Release History

Regards,
Boyan Dimitrov
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.
0
RICHARD
Top achievements
Rank 1
answered on 12 Dec 2017, 04:53 PM

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

0
Alex Hajigeorgieva
Telerik team
answered on 13 Dec 2017, 01:49 PM
Hi, Richard,

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
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Alex Hajigeorgieva
Telerik team
answered on 18 Nov 2020, 11:08 AM

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

Tags
PivotGrid
Asked by
Gus
Top achievements
Rank 2
Answers by
Georgi Krustev
Telerik team
Anand
Top achievements
Rank 1
Łukasz
Top achievements
Rank 1
Alex Hajigeorgieva
Telerik team
Boyan Dimitrov
Telerik team
RICHARD
Top achievements
Rank 1
Share this question
or