Example of Server-side Aggregation in ASP.NET MVC Pivot Table Control
This sample shows how to use a server-side pivot engine to fetch and display summarized data in the Pivot Table. It includes export options for Excel, CSV, and PDF with headers and footers, and a layout switcher to toggle between Compact and Tabular views at runtime.
The Pivot Table's server-side pivot engine (external pivot engine) uses the Syncfusion package Syncfusion.Pivot.Engineopens in a new tab to gather data from the data source and perform all pivot operations such as Aggregationopens in a new tab, Filteringopens in a new tab, Sortingopens in a new tab, Groupingopens in a new tab, and more on a separate hosted server and only paged data is sent to the pivot table viewport via web service. The DataSourceSettings->Urlopens in a new tab property allows this web service URL to be connected to the pivot table.
In this demo, the Pivot Table is rendered using an external server-side engine, which significantly enhances performance when handling large datasets. By offloading data processing to the server, client-side rendering becomes faster and more efficient—ensuring a smoother user experience even with complex or high-volume data.
For further performance improvements when working with large data volumes, we recommend enabling virtualization or paging features.
The built-in toolbar includes export options for Excel, CSV, and PDF documents. These export features support adding headers and footers, enabling enriched document formatting and presentation.
Additionally, a custom toolbar menu is provided to switch between Compact and Tabular layouts at runtime, offering flexibility in how the summarized data is displayed.
More information about server-side aggregation can be found in this documentation sectionopens in a new tab.