Pivot Table column per group row

[Bill Naples]

The Pivot Table combines all group captions into a single column, like this:

But I'd like each group to be displayed as a separate column, e.g., Country is one column, Products is a separate column. It can be easier to read that way. Also when exporting it to Excel, then the user can set up a native Excel Pivot Table from it.

Ag-Grid has this feature as shown here:

https://www.ag-grid.com/javascript-data-grid/grouping-multiple-group-columns/

Does SyncFusion has this capability? If so, how do we configure it? If not, can you please submit a feature request for it?

Thanks.

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Bill,

We believe that your requirement is to display the pivot table in "Classic layout" (aka, Excel's "Tabular" form). If so, we regret to inform you that the pivot table does not support classic layout. Our Syncfusion Pivot Table can only display Excel-like layouts, which are nothing more than Excel's "Compact" form.

Excel Pivot table(Compact view)	Syncfusion Pivot table

Furthermore, we regret to let you know that, based on the current architecture, currently we don’t have plan to implement the classic layout in our Syncfusion pivot table.

Regards,

Angelin Faith Sheeba.

[Bill Naples]

☹️☹️☹️☹️☹️

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Bill,

We would like to let you know that, when compared to the "Classic" layout (i.e., Excel's "Tabular" form), our pivot table in "ExcelLikeLayout (i.e., Compact view)" that displays row fields in grouping with slight indentation based on row level, appears more compact, especially when compared to the tabular form, which displays each Row field in a separate column in the pivot table. As a result, the Syncfusion Pivot Table component prefers the Excel-like layout over "Classic" layout. In addition, the compact form is the default format of Microsoft Excel sheets in recent versions. So, we recommend that you give it a shot, and we believe our current pivot table layout will be beneficial to your projects.

Regards,

Angelin Faith Sheeba.

[Bill Naples]

Customers have asked us for the "classic" layout, so we want to listen to our customers' needs.

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Bill,

We regret to inform you that our pivot table engine, as well as the UI rendering architecture, are currently built and work solely on the compact layout in our pivot table. Therefore, considering the classic layout in our Pivot Table will lead in structural complexity on changing our current architecture. Furthermore, as we are already working on our roadmaps and other high priority items for upcoming releases. Furthermore, due to the current architecture, we are unable to consider this support for the time being. However, if we plan to integrate this feature in the future, we will notify you.

Please let us know if you have any concerns.

Regards,

Angelin Faith Sheeba.