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.
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)
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!