Pending Review
Last Updated: 24 Sep 2019 10:57 by ADMIN
Created by: Sebastian
Comments: 5
Category: PivotGrid
Type: Feature Request
34
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
Pending Review
Last Updated: 08 Nov 2017 16:23 by ADMIN
Created by: andrew
Comments: 3
Category: PivotGrid
Type: Feature Request
27
Your friend  devexpress have very nice compact pivot grid layout
https://demos.devexpress.com/MVCxPivotGridDemos/Layout/CompactLayout

Can we also have it on kendo ui ?
Pending Review
Last Updated: 28 Aug 2018 01:22 by ADMIN
Created by: Sebastian
Comments: 0
Category: PivotGrid
Type: Feature Request
26
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
Pending Review
Last Updated: 12 Oct 2018 16:14 by ADMIN
Created by: Robert
Comments: 0
Category: PivotGrid
Type: Feature Request
23
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. 
Pending Review
Last Updated: 17 Dec 2018 14:22 by ADMIN
Created by: Erik
Comments: 2
Category: PivotGrid
Type: Feature Request
20
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.
Pending Review
Last Updated: 09 May 2018 16:44 by ADMIN
Created by: Sebastian
Comments: 0
Category: PivotGrid
Type: Feature Request
15
The PivotConfigurator is very static. It would be nice to change the layout.

For example some options:
- Hide / visibility of all four elements (Row, Column, Measure, Fieldlist)
- Position of all four elements (Row, Column, Measure, Fieldlist)
Completed
Last Updated: 08 Jun 2017 13:01 by ADMIN
Created by: Piyush Bhatt
Comments: 4
Category: PivotGrid
Type: Feature Request
15
Currently Pivot Grid has very limited support for flat data. Please include a library so we can emulate OLAP on the MVC controller side for the FLAT data and can use full features of the PIvot Grid.

OR somehow fully support the FLAT data in Pivot Grid (including Configurator, Filtering etc)
Pending Review
Last Updated: 08 Oct 2018 11:54 by ADMIN
Created by: michael
Comments: 0
Category: PivotGrid
Type: Feature Request
14
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
Pending Review
Last Updated: 30 Jan 2018 11:02 by ADMIN
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.
Pending Review
Last Updated: 10 Sep 2018 20:27 by ADMIN
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.
Pending Review
Last Updated: 25 Apr 2017 16:23 by ADMIN
Created by: Rajan
Comments: 2
Category: PivotGrid
Type: Feature Request
10
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
Pending Review
Last Updated: 28 Feb 2017 22:07 by ADMIN
In SSAS world you can often see mega cubes with many measures and dimensions. Currently Kendo pivot grid configurator does not show measure groups and therefore there is no way to filter dimensions and filters that belong to a specific measure group.
Pending Review
Last Updated: 24 Feb 2017 09:45 by ADMIN
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. 
Pending Review
Last Updated: 15 Mar 2018 08:17 by ADMIN
Created by: Fernando
Comments: 0
Category: PivotGrid
Type: Feature Request
7
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.
Pending Review
Last Updated: 14 Mar 2018 20:32 by ADMIN
Created by: Sebastian
Comments: 0
Category: PivotGrid
Type: Feature Request
6
What we would need is te possibility to show the percentage of the gand total summary.
For example:

row / column value
1 / 2
2 / 3
3 / 5
summary / 10

=> change calculation to percent of grand total

1 / 20%
2 / 30%
3 / 50%
Pending Review
Last Updated: 11 May 2016 07:34 by ADMIN
Created by: Sebastian
Comments: 3
Category: PivotGrid
Type: Feature Request
6
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.
Pending Review
Last Updated: 31 Aug 2016 17:12 by ADMIN
An OData feed that supports 'OData Extension for Data Aggregation Version 4.0'
can be queried for all of the information required to populate a PivotGrid
with rows and columns that are paged, sortable (including by different aggregates
of the measures), and filterable, and have all calculations performed on the server.

The pivot grid can be popualted using data obtained from a couple of requests
to a suitable feed -- or feeds.

Suppose we have an OData feed that we'd like to display in a pivot grid. Some of the 
columns in the feed will become dimensions, and some will become measures.
(We may display the same measure more than once, with different aggregates applied.)

In order to display the row/column headings for the pivotGrid we need to select the 
distinct values from the 'dimension' columns. The filtering provided by OData 
allows the row/column headings to be filtered, and even
paged (in both directions). Sorting is more difficult because we want to sort not only 
by the row/column heading values themselves, but also by (aggregates of) the measures.
However, that's a problem for the server side!

In order to populate the body of the table we need to calculate a load of aggregates
from the measure columns in the base dataset for the rows that correspond to visible
row/column headers. We can write a rather long OData $filter expression to obtain 
the required rows from the original OData feed, and then aggregate them.

All of this functionality is available in 'OData Extension for Data Aggregation Version 4.0'.
However, as an interim solution we may establish two 'helper' OData feeds associated
with the original feed: one for the dimensions for populating the row and column headers,
and one for the measures to populate the body of the table. The grid has already
established a convention for asking for aggregates computed on the server,
although this can be overridden using parameterMap anyway.
Pending Review
Last Updated: 03 Aug 2016 04:46 by ADMIN
As per this post: http://www.telerik.com/forums/pivotgrid-bug

When using PivotGrid with a flat data source the handles for dragging the dimensions are labelled with a different string to the dimension headers.

The dimension headers are labelled with the dataSource.schema.cube.dimensions.[name].caption.

The dimension drag handles are labelled with the dataSource.rows.name (or dataSource.columns.name).

Now, the dataSource.rows.name must be the key in the dataSource.schema.cube.dimensions of the dimension and this must also be a key in each item in the data array -- the field that stores the value of the dimension -- and therefore is in general not suitable for showing to users.

In any case, it seems to me to be a bug that the drag handle is labelled with a different string to the dimension caption.
Completed
Last Updated: 15 Feb 2017 09:12 by ADMIN
Created by: Alexandru
Comments: 2
Category: PivotGrid
Type: Feature Request
5
Currently the Kendo PivotGrid always starts out with one tuple for each dimension on rows and columns, and you can recursively expand members to get to their children. However, even with a moderately deep hierarchy, this quickly consumes a lot of screen real estate.

It would be useful to have the option to drill-down in addition to expand. I understand that it's not an easy feature to design and implement, mainly due to the merging of cells that occurs when expanding, which is also the reason why the grid must always have one single member on the first level of a dimension on rows/columns; but I'm hoping someone can come up with an idea that would make it easier.

Cheers!
Pending Review
Last Updated: 11 May 2016 12:51 by ADMIN
Currently measures are displayed as dimensions and there is no visual difference  between them.
I suggest you showing measures as a very first item in the pivot grid configurator. Also please use a  meaningful icon for this item.
1 2