Features and Benefits
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.
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.
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.
Sorting supports to order rows and columns based on either labels or values.
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.
The calculated field, otherwise known as unbound field generates unique field with our own calculated value by executing a simple user-defined formula.
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.
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.
You can freeze row and column headers to scroll and compare cell values with the corresponding row and column headers.
Web framework integration
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.