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)
Done: http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/overview#filtering
`Flat data` binding seems to support filtering - http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/overview#filtering
This is kind of related to http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/9218646 A number of 'queries' on the flat data can be used to assemble the row and column headers for a cross-tabular display and even page in both directions. I have a C# 'query manipulator' that can provide the required related data sets from a base SQL query; I am happy to share if we can get some movement on better support for flat data and on paging in the pivot grid...
Sorting (not only by number/text, but with date support too) would be nice to have.