ASP.NET Core Pivot Table - Syncfusion ASP.NET Core UI ControlsThe ASP.NET Core pivot table control organizes and summarizes business data and displays the result in a cross-table format. A high volume of pivot data can be loaded without any performance degradation using row and column virtualization. |
The ASP.NET Core Pivot Table is a powerful control used to organize and summarize business data and display the result in a cross-table format. This control includes major functionalities such as data binding, drilling up and down, Excel-like filtering and sorting, editing, Excel and PDF exporting, several built-in aggregations, field lists, and calculated fields. A high volume of data can be loaded without any performance degradation by using row and column virtualization.
Features and BenefitsHigh performanceASP.NET Core Pivot Table allows users to load large amounts of raw data into the pivot engine, aggregate it, and view it on-demand through virtual scrolling options with ease. Data bindingJSON formatYou can bind JSON data to the control to work smoothly within applications. The JSON data can be obtained from a local file, remote file, or web service. CSV formatYou can also bind CSV data to the control. The CSV data can be obtained from a local file, remote file, or web service. OLAP data bindingThe ASP.NET Core Pivot Table can be connected to an OLAP cube, and its result can be visualized in both tabular and graphical formats. Remote data bindingBinding the ASP.NET Core Pivot Table with RESTful services allows data from any source, including Excel and CSV files; SQL databases like Microsoft SQL, MySQL, and PostgreSQL; and collections like IEnumerable, IList, and array lists through services, to be consumed using the data manager explicitly. Data Manager supports various data adaptors such as JSON, OData, ODataV4, URLs, and web APIs for working with particular data services. Pivot ChartThe ASP.NET Core Pivot Chart can easily be integrated with pivot data rendered independently, and includes support for plotting more than 30 chart types. The end-user experience is greatly enhanced with a set of user-interaction features such as drill up, drill down, zoom, pan, crosshair, trackball, events, selection, and tooltip. Highly interactive field list options are available for generating reports from the relational data dynamically. Optimized for mobile devicesTouch supportAll features will work on touch devices with ease. Features such as drilling up, drilling down, filtering, sorting, and report manipulation can be done on the fly. ResponsivenessResponsive support allows the control to be viewed on various devices in Core Pivot Table. Adaptable field list UIThe Pivot Table field list can be displayed on various devices in a presentable manner. Pivot Table field list and group fieldsThe ASP.NET Core Pivot Table field list and group fields option are automatically populated with fields from the bound data source. They allow end users to drag, filter, and sort fields, as well as create pivot reports at runtime. Drill down and drill upProvides built-in drill-down (expand) and drill-up (collapse) capabilities to visualize data in detailed views and abstract views, respectively. By default, the data is displayed in a grouped manner. Defer layout updateUsers can refresh the control on demand instead of during every UI interaction in the Pivot Table. Defer layout update documentation Editing and updatingUsers can perform create, read, update, and delete operations for raw data at runtime and update their changes to the underlying data source, thereby reflecting the information in all corresponding cells. The control supports various edit modes such as inline, dialog, batch edit, and column edit through an interactive UI. Editing and updating documentation FilteringBuilt-in member function and Excel-like filters with advanced filtering options can be used to easily filter and view data as required. It is also possible to filter data programmatically in the Pivot Table. Header filteringHeader filtering displays only selected values for a field. This can be achieved either through the UI or programmatically. Normal filtering documentation Label filteringUse Excel-like filtering options across column and row headers based on label text, date, or number. Value filteringUse Excel-like filtering options across column and row headers based on grand-total values. SortingHeader sortingOrder column and row header text either in ascending or descending order. Column sortingColumn sorting, also known as value sorting, orders the column values either in ascending or descending order. It is performed by clicking the header of the column you wish to sort. AggregationUsers can perform calculations on a group of values using the aggregation option. By default, values are added together. The other aggregation types are average, minimum, maximum, count, distinct count, product, index, population standard deviation, sample standard deviation, population variance, sample variance, running totals, difference from, percent of difference from, and percent of grand total. Calculated fieldsCalculated fields, otherwise known as unbound fields, generate unique fields with your own calculated values by executing a simple user-defined formula. Calculated field documentation Drill throughThe drill-through feature easily obtains a list of raw items for a particular value cell or summary cell. TotalsSubtotals and grand totals are calculated automatically by the pivot engine inside the control and displayed in the Pivot Table to help users make decisions more quickly. Also, users can show or hide subtotals and grand totals for rows and columns. Show or hide totals documentation Conditional formattingConditional formatting allows users to define conditions that, when met, format font style, text color, background color, and font size for values and summary cells. Conditional formatting documentation Number formatting and date formattingNumber formatting and date formatting help transform the appearance of the actual cell value. Format settings in API documentation Group dates and numbersThe ASP.NET Core Pivot Table control automatically groups dates and numbers, so the date type can be formatted and displayed based on year, quarter, month, day, and more. The number type can be grouped by range, such as 1-5 or 6-10. Grouping date and number documentation Frozen headersYou can freeze row and column headers to compare cell values with the corresponding row and column headers. Columns and rowsResizeResizing allows changing column width at runtime by simply dragging the rightmost boundary of the column header. A scroll bar will appear when the content width exceeds the control width. ReorderYou can reorder columns either on user interaction or programmatically. Simply dragging and dropping a column header into the desired column position will reorder the columns. HyperlinkUsers can retrieve information about a particular cell on clicking a hyperlink cell. It later allows them to perform custom operations programmatically. Cell selectionSelect a range of cells. TooltipA tooltip provides basic information about a cell while hovering over it with the pointer in Core Pivot Table. Cell templatesWith cell templates, users can add features like images, check boxes, and text nodes to any cell with ease. ToolbarThe Toolbar feature provides a built-in interface to select frequently used features interactively. These features include new report, save report, save as report, rename report, delete report, report list, show grid, show chart, show or hide totals, export reports, and more. ExportingExport the ASP.NET Core Pivot Table data to Excel, PDF, and CSV formats. You can also customize the exported document by adding header, footer, and cell properties like type, style, and position programmatically. Custom styles and themesBuilt-in themesShips with a set of four stunning, built-in themes: Material, Fabric, Bootstrap, and high contrast. Custom stylingYou can customize the appearance of the control as little or as much as you like programmatically. Globalization and localizationGlobalizationGlobalization enables users from different locales to use the control by formatting the date, currency, and numbering to suit locale preferences. This uses an internalization (i18n) library for handling value formatting. Right to left (RTL)Supports right-to-left rendering and allows the text direction and layout of the control to be displayed from right to left. LocalizationYou can localize all the control’s strings in the user interface as needed and use the localization (l10n) library to do so. Developer-friendly APIFor a great developer experience, flexible built-in APIs are available to define and customize the ASP.NET Core Pivot Table control. Developers can optimize the data bound to the control and customize the user interface completely using code with ease. Cross-browser compatibilityThe ASP.NET Core Pivot Table works on all major browsers across Windows, macOS, Linux, Android, and iOS devices. Our control is written in pure JavaScript and does not require any plugins on any modern web browsers. It provides a seamless working experience for all Chrome, Firefox, Internet Explorer, Safari, and Opera browsers. Web framework integrationThe pivot table control integrates easily with any web framework:
Related linksLearn More about ASP.NET Core Pivot Table About Syncfusion ASP.NET Core UI ControlsSyncfusion's ASP.NET Core UI controls library is the only suite that you will ever need to build an application since it contains over 85 high-performance, lightweight, modular, and responsive UI controls in a single package. In addition to Pivot Table, we provide popular ASP.NET Core Controls such as DataGrid, Charts, Scheduler, Diagram, and Word Processor. About SyncfusionFounded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 29,000 companies and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies. Today, we provide 1800+ controls and frameworks for web (ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React, Blazor, Vue, and Flutter), mobile (Xamarin, UWP, JavaScript, and Flutter), and desktop development (Windows Forms, WPF, UWP, Flutter, WinUI, and .NET MAUI). We provide ready-to-deploy enterprise software for dashboards, reports, data integration, and big data processing. Many customers have saved millions in licensing fees by deploying our software. sales@syncfusion.com | Toll Free: 1-888-9 DOTNET |
