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 ?

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.

Regards

Miron Konrad

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!