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 want to control the visibility of the total and sub-total. I want to be able to hide them if needed.

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

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

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

Hello,

in the WPF Pivot component I created custom calculated fields. Please expose a similar feature in the Blazor PivotGrid.

https://docs.telerik.com/devtools/wpf/controls/radpivotgrid/features/queryabledataprovider/queryable-calc-fields

var OeeA = new OeeA_BerechnetesFeld(); //Telerik.Pivot.Core.CalculatedField
OeeA.Name = "OEE A";
DataSource.CalculatedFields.Add(OeeA); // DataSource is the LocalDataSourceProvider

DataSource.AggregateDescriptions.Add(new CalculatedAggregateDescription { CalculatedFieldName = "OEE A", StringFormat = "#.#0" });

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.

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

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

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 want to apply CSS class to the headers, so I can easily style them.

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.

I had already tried using reflection via dataTemplate to access the ColumnGroup and RowGroup properties. It would be nice if in future versions, if possible, these were accessible directly and without having to use reflection for efficiency reasons. Expose the current field as well.

In addition to this, it would be convenient to know which row and column they refer to, in order to know which field of the Pivot dataset relates to the calculation performed, and apply custom logic to them.

In summary, expose: ColumnGroup, RowGroup, and the current field.

Currently, the PivotGrid data can only be sorted within the PivotGrid configurator.