Example of Classic Layout in ASP.NET MVC Pivot Table Control
This sample showcases the classic layout option of the Pivot Table, also known as the Excel-like tabular format. In this layout, each field from the row and column axes is arranged sequentially, displayed side by side in separate rows or columns. Subtotals and grand totals are prominently shown, making it easy to compare and analyze data effectively.
The Pivot Table's classic layout displays each field in the row axis side by side in separate columns. By default, grand totals are displayed at the end of all rows, while subtotals are placed in a separate row beneath each group. All other features of the pivot table, such as filtering, sorting, drag-and-drop, expand/collapse functionality, and more, remain the same as in the Compact (Excel-like) layout, which serves as the default layout for the Syncfusion® Pivot Table.
This layout can be enabled by setting the Layout
property to Tabular within the GridSettings.
Using the Classic Layout toggle switch, the pivot table layout can be dynamically switched between
Compact and Classic layouts at runtime.
Note: For pivot table reports containing multi-level hierarchies with extensive sublevels, the default layout (i.e., compact view) is recommended, as it effectively displays data in a simple and compact manner.
More information on the ASP.NET MVC Pivot Table can be found in this documentation section.