At the moment it's possible to drag & drop fields into the grid. But it's not possible to set the field at a specific position. That is very unusual. I would expect to see a position marker while hovering with a fields over the drop area. When ein drop the field it goes there where the marker was.
Hi Team,
I would like to request Selection/multi-cell drag selection for the Kendo UI PivotGrid.
Thank you!
In some applications data will be so huge to load on PivotGrid, and the manipulation of filtering, reordering and changing dimensions between rows and columns take a long time, freezering the browser for a moment. With data paging this frozen time is avoided.
Expanding programmatically all paths in a level in a pivot grid is coumbersome. One should be able to expand all itlems in a level. Also when one row.expand and column.expand configuration should work for all levels.
Add the option to connect to Microsoft SSAS Tabular mode using Kendo UI PivotGrid
Now if you set filterable true for KendoPivotGrid you get two options - Include Fields and Fields Filter. In some cases you need only one of this options and it is not good to be with one option - filterable.
As of August 2018, the PivotConfigurator can show a list of dimensions and measures. However, the control could be improved by optionally adding the members of dimension attributes to the control. By allowing users to drag-and-drop members, they can add a dimension and instantly filter by the selected member. This would speed up the process of designing sophisticated queries. Thanks!
We have an existing application that was developed with ExtJS, that we'd like to move to AngularJS+KendoUI. The only thing that's holding us back is that you don't have the ability to created editable PivotGrids. That feature is available in Sencha's product, and our users use it extensively. Ex: http://examples.sencha.com/extjs/6.0.2/examples/kitchensink/#rangeeditor-pivot-grid
Kendo pivotgrid currently has only row and column filters. Filters and Filter area are also important. See other pivotgrid implementations - especially DevExpress ASPxPivotgrid and Excel pivot table
Hello,
I have a problem with KendoPivotGrid auto height while using jQuery 3.5.5.
See Dojo
The same issue was previously in KendoGrid, but now it's solved.
Advanced functionality in xml/a binding should be available to local binding. Also ability to define new binding protocols.
Currently there is no way to select database and cube in the analyzer. http://demos.telerik.com/kendo-ui/pivotgrid/index Please consider this functionality.
You really need to add sorting to your Kendo UI pivotgrid for flat/local data sources. The entire point of a pivot grid is to analyze data. We did a POC with it for our salesmen. The feedback was: "It's almost useless if I can't sort it and see my top and bottom sellers, etc...". So, we're swapping out the pivotgrid for Infragistics Ignite UI. It's a shame too, cause most everything else is there.
Kendo pivotgrid does not allow us to hide 'All' row/column.'All' row/column is not always needed in a OLAP report. Excel would allow us to hide/eliminate subtotall rows/columns. pivotgrid needs similar functionality. In general emulate Excel pivotgrid functionality in kendo pivotgrid
I would like to see a persist state feature like in the grid control applied to the pivot grid. A complex cube state is difficult for our users to set up each time the page is loaded. It would be great to save the current state of the pivotgrid and restore it on future visit.
Problem: The values and fieldnames can be very long or very short. Based on that, values and fieldnames are often truncated or lost in a way to wide column. That behavior has many downsides: - The PivotGrid need much more space then it should - Long values and fieldnames can't be read - It's totally not responsive and looks bad Competitors solution: - http://www.igniteui.com/pivot-grid/all-grid-features - http://webix.com/pivot/ Problem-solving approach: - Show resize icon when hovering over a the bar between two columns - Resize this column to it's min. width (value or fieldname) after a double click on this bar - Manual resizing of the column by drag and drop of this bar - Automatically size columns to there min. width on initialisation
I want to sort rows and columns by values (not fieldnames). One way to do that is like it's done by DevExpress (https://demos.devexpress.com/ASPxPivotGridDemos/OLAP/Browser.aspx). By right clicking a field i can choose for with field, row, column and measurement i want to sort. But even this solution could be more userfriendly. Another more direct solution would be to sort by clicking on a measurement field or if there is only one, on a fieldname. Both are just suggestions. But the functionality of sorting by values is really relevant. http://www.telerik.com/forums/sort-rows-and-columns-by-values