JavaScript Pivot Table - Syncfusion JavaScript UI Controls

The JavaScript 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.

syncfusion javascript pivot table control showcase

Features and Benefits

High performance

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 binding

The JavaScript pivot table accepts JSON array for data binding. It uses the data manager explicitly to handle remote data and data processing.

JSON format - array of objects - You can bind an array of objects to the control to work smoothly in applications.
Remote data binding - Binding the JavaScript pivot table with RESTful services allows data from any sources, including Excel and CSV files, SQL databases like Microsoft SQL, MySQL, and PostgreSQL, and collections like IEnumerable, IList, and array lists through services, which are consumed using the data manager explicitly. It supports various data adaptors such as JSON, OData, ODataV4, URL, and Web API for working with particular data services.

Pivot table field list and group fields

The 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 report at runtime.

Drill down/Drill up

Provides built-in drill down (expand) and drill up (collapse) capability to visualize data both in a detailed view and abstract view, respectively. By default, the data are displayed in a grouped manner.

Filtering

Built-in normal and Excel-like filters with advanced filtering options to easily filter and view data as required. It is also possible to filter programmatically.

Header filtering - Displays only selective values for a field. This can be achieved either through UI or code-behind.
Label filtering - Excel-like filtering option across column and row headers either based on label text, date, or number.
Value filtering - Excel-like filtering option across column and row headers based on grand-total value.

Sorting

Sorting supports to order rows and columns based on either labels or values.

Header sorting - Orders the column and row header text either in ascending or descending order.
Column sorting - Column sorting, also known as value sorting, orders the column value either in ascending or descending order. It is performed by clicking the desired column header.

Aggregation

Users can perform calculations over a group of values using the aggregation option. By default, values are added together. The other aggregation types include average, minimum, maximum, and count.

Calculated field

The calculated field, otherwise known as unbound field generates unique field with our own calculated value by executing a simple user-defined formula.

Totals

Subtotals and grand totals are calculated automatically by the pivot engine inside the control and displayed in the pivot grid. This helps users make decisions based on the totals.

Conditional formatting

Allows users to define conditions that, when met, format font style, text color, background color, and font size for values and summary cells.

Number formatting and date formatting

Number formatting and date formatting help to transform the appearance of the actual cell value.

Frozen header

You can freeze row and column headers to scroll and compare cell values with the corresponding row and column headers.

Column

Resize - Resizing allows changing column width at runtime by simply dragging the right-most boundary of the column header. The scroll bar will appear when the content width exceeds the control width.
Reorder - You can reorder the columns either on user interaction or programmatically. Simply dragging and dropping a column header into the desired column position will reorder the columns.

Exporting

Exports JavaScript pivot table data to Excel, PDF, and CSV formats. You can also customize the exported document by adding the header, footer, and cell properties like type, style, and position programmatically.

Web framework integration

As a pure JavaScript component, the pivot table control integrates easily with any web framework:

About Syncfusion

Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 20,000 customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.

Today we provide 1000+ controls and frameworks for web (ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React or Vue), mobile (Xamarin, UWP and JavaScript), and desktop development ( WinForms, WPF & UWP). 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 | www.syncfusion.com | Toll Free: 1-888-9 DOTNET