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.

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.

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

The component struggles to update Local data source when it changes. I have bound it to a value, but when that value changes it is not reflected in the UI.

The issue occurs when you update the data with an entirely new collection. Calling Rebind afterwards does not help either.

Reproduction: https://blazorrepl.telerik.com/QdvFEDkq548ianYG37.

===

ADMIN EDIT

===

A possible workaround for the time being is to dispose and re-initialize the component when the new data arrives. Here is an example: https://blazorrepl.telerik.com/cHFlaNOg49AjRPUl19.

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

I want to control the visibility of the total and sub-total. I want to be able to hide them if needed.

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

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?

There is sorting which works well, but no visual indicator to show to the user the current sort (like the TelerikGrid).

I want to be able to change the aggregate (sum/min/max etc) of measures at runtime.

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.

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

I am binding the PivorGrid to local data and I am validating that the list contains some records. However, the PivotGrid appears empty. It looks like if the data arrives after PivotGrid initializes, the component does not display it.

Reproduction: https://blazorrepl.telerik.com/GnYDuvFP13H5RQwk31.

===

ADMIN EDIT

===

A possible option to handle the scenario for the time being is to ensure the PivotGrid initializes only when the data is available. For that purpose, you can conditionally render the component based on the data count. Optionally, you can show a LoaderContainer while the data is being fetched.

Here is an example that showcases the approach: https://blazorrepl.telerik.com/cdujObbF15YVdqvR54.

I want to keep the standard numeric values in the cells but I also want to show a separate column to display the cell values in percent of the column total. Similar to the PercentOfColumnTotal option in Ajax PivotGrid.