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
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.
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 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.
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
Setting dimensions in pivot grid with fields of data type "number" or "date" the filter menu opens with conditions and input component as if the fields are of "string" type, how do I configure the filter menu to act according it's data type.
In case of date/number data type, in the Include fields filter the selected items are not persistent - when a user selects some of the values and reenters the include fields the selected values are not saved.