The Blazor Pivot Table is a powerful control used to organize and summarize business data and display the result in a cross-table format. It 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, pivot table field list, and calculated fields. A high volume of pivot data can be loaded without any performance degradation using row and column virtualization.
You can bind JSON data to the control enabling it to work smoothly in applications. JSON data can be obtained from a local file, remote file, or web service.
You can also bind CSV data to the control. CSV data can be obtained from a local file, remote file, or web service.
The Blazor Pivot Table can now be connected to OLAP cube and its result visualized in both tabular and graphical formats.
Binding the Blazor 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 to be fetched using the data manager. It supports various data adaptors such as JSON, OData, ODataV4, URL, and Web API for working with appropriate data services.
Blazor pivot charts can easily be integrated with pivot data rendered independently, including functionality for plotting more than 20 types of pivot charts. The end user experience is greatly enhanced by including a set of user-interactive features such as zooming, panning, crosshair, trackball, events, selection, and tooltip. Highly interactive field list options are available for generating reports on top of the relational data dynamically.
All features will work on touch devices. Features such as drill up/down, filtering, sorting, and report manipulation can be done on the fly.
Responsive support allows the component layout to be viewed on various devices.
Allows the pivot table field list UI to be viewed according to various devices.
The Blazor 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.
Provides built-in drill down (expand) and drill up (collapse) capabilities to visualize data both in a detailed view and abstract view, respectively. By default, data is displayed in a grouped manner.
Users can refresh the component on demand instead of during every UI interaction in the Blazor Pivot Table.
Users can 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 component supports various edit modes such as inline, dialog, batch edit, and column edit through an interactive UI.
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.
Displays only selective values for a field. This can be achieved either through UI or code-behind.
Excel-like filtering option across column and row headers based on label text, date, or number.
Excel-like filtering option across column and row headers based on the value of the grand-total.
Rows and columns are ordered based on either labels or values.
Orders the column and row header text either in the ascending or descending order.
Column sorting, also known as value sorting, orders the column value either in the ascending or descending order. It is performed by clicking the desired column header.
Users 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 stdev, sample stdev, population var, sample var, running totals, difference from, % of difference from, and % of grand total.
The calculated field, otherwise known as unbound field, generates a unique field with the user’s own calculated value by executing a simple user-defined formula.
The drill-through feature easily obtains a list of raw items for a particular value cell or summary cell.
Subtotals and grand totals are calculated automatically by the pivot engine in the component and displayed in the pivot table. This helps users make decisions based on the totals. Also, users can show or hide subtotals and grand totals for rows and columns.
Allows users to define conditions that, when met, format font style, text color, background color, and font size for values and summary cells.
Number and date formatting helps transform the appearance of the actual cell value.
The Blazor Pivot Table component automatically groups dates and numbers, so that 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.
You can freeze row and column headers to scroll and compare cell values with the corresponding row and column headers.
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 component width.
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.
A tooltip provides basic information about a cell when hovering over it.
With cell templates, users can easily add features like images, checkboxes, and text nodes to any cell.
The Toolbar feature provides a built-in interface for pivot tables to select frequently used features interactively for easy access. 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.
Export Blazor 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.
Ships with several stunning, built-in themes namely Tailwind CSS, Bootstrap 5, Bootstrap 4, Bootstrap, Material, Fabric, and High Contrast.
You can customize the appearance of the component to any extent programmatically.
Enables users from different locales to use the component by formatting the date, currency, and numbering to suit locale preferences. This uses an internalization (i18n) library for handling value formatting.
Supports right-to-left rendering and allows the text direction and layout of the component to be displayed from right to left.
You can localize all the component strings in the user interface as needed and use the localization (l10n) library to localize UI strings.
For a great developer experience, flexible built-in APIs are available to define and customize the Blazor Pivot Table component. Developers can customize the user interface (UI) completely using code easily.
It is necessary for the Blazor pivot table to work on all major browsers across Windows, macOS, Linux, Android, and iOS. The component is written in pure JavaScript and does not require any plugin on any modern web browsers. It provides a seamless working experience for Chrome, Firefox, Internet Explorer, Safari, and Opera browsers.
Easily get started with the Blazor Pivot Table using a few simple lines of C# code as demonstrated below. Also explore our Blazor Pivot Table Example that shows you how to render and configure the Blazor Pivot Grid.
@using Syncfusion.Blazor.PivotView
<SfPivotView TValue="ProductDetails" Height="300">
<PivotViewDataSourceSettings DataSource="@dataSource">
<PivotViewColumns>
<PivotViewColumn Name="Year"></PivotViewColumn>
<PivotViewColumn Name="Quarter"></PivotViewColumn>
</PivotViewColumns>
<PivotViewRows>
<PivotViewRow Name="Country"></PivotViewRow>
<PivotViewRow Name="Products"></PivotViewRow>
</PivotViewRows>
<PivotViewValues>
<PivotViewValue Name="Sold" Caption="Units Sold"></PivotViewValue>
<PivotViewValue Name="Amount" Caption="Sold Amount"></PivotViewValue>
</PivotViewValues>
<PivotViewFormatSettings>
<PivotViewFormatSetting Name="Amount" Format="C"></PivotViewFormatSetting>
</PivotViewFormatSettings>
</PivotViewDataSourceSettings>
</SfPivotView>
@code{
public List<ProductDetails> dataSource { get; set; }
protected override void OnInitialized()
{
this.dataSource = ProductDetails.GetProductData().ToList();
}
public class ProductDetails
{
public int Sold { get; set; }
public double Amount { get; set; }
public string Country { get; set; }
public string Products { get; set; }
public string Year { get; set; }
public string Quarter { get; set; }
public static List<ProductDetails> GetProductData()
{
List<ProductDetails> productData = new List<ProductDetails>();
productData.Add(new ProductDetails { Sold = 97, Amount = 104168, Country = "United States", Products = "Road Bikes", Year = "FY 2016", Quarter = "Q4" });
productData.Add(new ProductDetails { Sold = 95, Amount = 837800, Country = "United States", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q1" });
productData.Add(new ProductDetails { Sold = 87, Amount = 684168, Country = "United States", Products = "Road Bikes", Year = "FY 2017", Quarter = "Q2" });
return productData;
}
}
}
Pivot Table is also available in Angular, React, Vue and JavaScript frameworks that are built from their own TypeScript libraries. Check out the different Pivot Table platforms from the links below,
We do not sell the Blazor Pivot Table separately. It is only available for purchase as part of the Syncfusion Blazor suite, which contains over 70 native Blazor components, including the Pivot Table. A single developer license for the Syncfusion Essential Studio for Blazor suite costs $995.00 USD, including one year of support and updates. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team today to see if you qualify for any additional discounts.
You can find our Blazor Pivot Table demo here.
No, our 70+ Blazor components, including Pivot Table, are not sold individually, only as a single package. However, we have competitively priced the product so it only costs a little bit more than what some other vendors charge for their Pivot Table alone. We have also found that, in our experience, our customers usually start off using one of our products and then expand to several products quickly, so we felt it was best to offer all 70+ Blazor components for a flat fee of $995/developer. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team today to see if you qualify for any additional discounts.
No, this is a commercial product and requires a paid license. However, a free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.
A good place to start would be our comprehensive getting started documentation.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.