I want to save or restore the state of the PivotGrid Configurator. Potentially, the user may have spent some time setting up their perfect PivotGrid that suited their needs, hence saving state seems critical.

===

ADMIN EDIT

===

The request covers exposing a state feature to programmatically manage various data operations in the PivotGrid - sorting, filtering, reordering of columns, expanding of items.

There is no property to rename fields in the XMLA dataset, so the user needs to see the full [Table].[ColumnName] attributes in its raw form (which ends up being quite ugly and potentially confusing for the user).

By default, the Telerik PivotGrid is always deferring the layout change. Usually on PivotGrids (Excel / PowerBI) there is a tick-box to allow the user to choose. For performant pivot tables, there is no need to defer the layout allowing for quick analytics.

In my example, the values are "Region 1", "Region 2", "Region 3", etc. and the component is also adding the labels of  "Region 1", "Region 2", "Region 3", etc.".  So with the label the pivot grid is adding, there values show twice.  My goal is to remove the generated label and only show the actual value.  In addition to looking better, it would also save space on the left side of the grid.

Is there a way to not have the Pivot Grid add those labels/headers to the rows so that only my value shows?

I would be much appreciated feature if we could export a pivot grid to excel in the same way that we can export a grid to excel.

Extra Credit:  As an added bonus, if the excel export was actually in an Excel Pivot Table format, that would be awesome.

Please expose an OnCellRender event, so I can add CSS class to the cells to easily style them.

I want to apply CSS class to the headers, so I can easily style them.

I'd like to allow the users to resize the columns, so they can see the full cell content.

Column auto-fitting can also be included.