Hi There,
When trying to build a tabular Pivot table report with multiple dimensions and attributes it becomes necessary to have the field names of the Row Labels, above the columns where the data appears. The reason is that it otherwise becomes impossible to know what data each column represents in the report making the PivotGrid useless for simple tabular reports. You can see below an instance of the issue and the equivalent report using Excel Pivot tables.
Attached are screenshots from Telerik PivotGrid(no row headers) and Excel Pivot tables(with row headers).
Can you help suggest a workaround to add row headers or is it scheduled in future release? Thanks!
10 Answers, 1 is accepted
We have included your feature request in our PITS - you can vote for it here. Our idea is to provide an easy way to modify RadPivotGrid without the usage of RadPivotFieldList. This will include the feature you've requested. Currently we do not have exact timeframe when we'll have this feature, but you can vote to raise its priority.
Hopefully this helps. Feel free to contact us in case you have any problems or concerns.
Regards,
Rosen Vladimirov
Telerik
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Rank 1
Agreed it would be a cool idea to manipulate a PivotGrid without the PivotFieldList, but the problem Ke mentions is more fundamental to the display of any PivotGrid in tabular format. If it is easier to implement just the display of the headers without allowing the user to graphically manipulate them inline, it would be a huge improvement.
Thanks,
John
I fully understand your concerns, but I want to assure you that the efforts to show headers is almost the same as the effort to have built-in way to control RadPivotGrid without RadPivotFieldList. That's why we've decided to include this feature in our to-do list, as showing the headers is in fact part of it.
Thank you for sharing your opinion. Feel free to contact us if you have any other suggestions or concerns.
Regards,
Rosen Vladimirov
Telerik
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
Rank 1
Are there any updates or custom source codes to display row header?
Regards
This feature is still in our to-do list. You can track its progress in our feedback portal.
Feel free to contact us in case you have any other problems or concerns.
Regards,
Rosen Vladimirov
Telerik
Rank 2
Hi There,
When trying to build a tabular Pivot table report with multiple dimensions and attributes it becomes necessary to have the field names of the Row Labels, above the columns where the data appears. The reason is that it otherwise becomes impossible to know what data each column represents in the report making the PivotGrid useless for simple tabular reports. You can see below an instance of the issue and the equivalent report using Excel Pivot tables.
Attached are screenshots from Telerik PivotGrid(no row headers) and Excel Pivot tables(with row headers).
Can you help suggest a workaround to add row headers or is it scheduled in future release? Thanks!
[/quote]
Hi,
I have the same request. When I set vertical layout = tabular I would like to see Row labels on the headers (in excel this feature is called Classic PivotTable Layout, https://www.extendoffice.com/documents/excel/2141-excel-classic-pivot-table-layout.html ).
How can I do it?
I am afraid that a mechanism to do this out of the box is not yet implemented. I would suggest your to follow the feedback item in the portal. This way you will be notified as soon as there is any change in its status.
Regards,
Martin Ivanov
Progress Telerik
Rank 1
Hello Vladimir,
Is this feature implemented? If yes, how to enable it? My pivot does not show the headers, so if it is implemented I guess it is disabled by default.
Thank you
Regards
Stephan
Hello Stephan,
This feature is not implemented yet. Please follow the feedback item in order to get notified when its status changes.
https://feedback.telerik.com/wpf/1350454-pivotgrid-configuring-pivotgrid-without-pivotfieldlist
Regards,
Martin Ivanov
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.
Rank 1
Iron
The feature is implemented through the FieldListBehavior.
About the export to Excel, you can modify the exporting Workbook document as you like by using the RadSpreadprocessing library.