I'd like to be able to set width to the columns to ensure the data inside them will be visible. Similar to https://docs.telerik.com/kendo-ui/api/javascript/ui/pivotgrid/configuration/columnwidth.

Hello

Just testing the new PivotGrid and a few features seem missing which may be critical and I cannot see an easy way to customise via templates or the like.
Apologies in advance if I have just missed it in the documentation or my understanding.

In my opinion, the main purpose a developer would put a PivotGrid into a web application;

• To simplify data "slicing and dicing" for users not comfortable with tools such as Excel/PowerBI, and reduce the need to export to Excel.
• To synchronise a pivotGrid view with other components/controls and/or charts on the page

 

Critical

1. No width parameter: This seems quite critical for general formatting purposes
2. No mouse hover: Considering there is no width parameter, then there should at least a mouse hover so that the user can hover to see content which has been cut-off due to insufficient width (like the TelerikGrid).
3. Defer Layout Update: 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 anaytics.
4. No "Title" attribute or alias for xmla fields: 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).
   eg: <PivotGridRow Name="[Product].[Category]"></PivotGridRow>
5. No event handlers: I cannot see any event handlers at all on this control? There are many user-triggered events which could be triggered within the GridConfigurator. This would be critical to synchronise the PivotGrid with any other controls, with the PivotGridEventArgs holding data of what was modified and if the modification was made to the PivotFields or Measures.
6. No state management: Cannot save or restore state of GridConfigurator. Potentially, the user may have spent some time setting up their perfect PivotGrid that suited their needs, hence saving state seems critical.
7. No programmatic control via @ref="PivotGrid": Cannot programmatically control the PivotGrid. This would be important to enable synchronisation between other Telerik controls / items on the page.

 

Less Critical

1. Export: Not critical but some form of export (Excel/PDF), to allow user to save the results.

 

Aside from that, all good and works well.

 

Cheers
Phil

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 be able to change the aggregate (sum/min/max etc) of measures at runtime.

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

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.