Column layout of Pivot Table
Hi Nickolay,
We have checked the image provided, and we believe that your requirement is to display the pivot table in a "Classic layout" (also known as Excel's "Tabular" form). If so, we regret to inform you that our Syncfusion Pivot Table currently only supports to display as Excel-like layout, which is nothing more than Excel's "Compact" form.
Furthermore, when compared to the "Classic" layout (i.e., Excel's "Tabular" form), our pivot table in "ExcelLikeLayout (i.e., Compact view)" appears more compact, allowing more value data to be displayed on the current view page, as compared to the tabular form, which displays each row field in a separate column in the pivot table resulting in number of row level increase, value data to display would be in less in current view page. Therefore, Syncfusion Pivot Table component prefers the "Compact" form over the "Tabular" form. In addition, the compact form is the default format for Microsoft Excel sheets in recent versions. So, we encourage you to give it a try, and we believe our current pivot table layout will be beneficial to your projects.
Demo:
https://ej2.syncfusion.com/angular/demos/#/material3/pivot-table/overview.html
|
Excel Pivot table (Compact view) |
|
|
Syncfusion Pivot table |
|
Please let us know if you have any concerns.
Regards,
Angelin Faith Sheeba.
