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