We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies


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.

Data binding

Blazor Pivot Table component renders with relational data source in JSON format.

JSON format

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.

Blazor Pivot Table component renders with relational data source in CSV format.

CSV format

You can also bind CSV data to the control. CSV data can be obtained from a local file, remote file, or web service.

Blazor Pivot Table component renders with olap data source.

OLAP data binding

The Blazor Pivot Table can be connected to OLAP cube and its result visualized in both tabular and graphical formats.

Remote data binding, remote web service and RESTful API in Blazor Pivot Table component.

Remote data binding

Binding the Blazor 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 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.

Pivot Chart

The Blazor Pivot Chart 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.

Blazor Pivot Table and pivot chart.

Virtual scrolling in Blazor Pivot Table component.

Virtual scrolling

Large amounts of data can be divided and displayed in the rows and columns of the current viewport using the virtual scrolling feature. You can navigate to a desired view by scrolling the vertical and horizontal scrollbars.


Large amounts of data can be divided and displayed page by page using the paging feature. The pager UI allows users to navigate to the desired page using the navigation buttons or an input text box. Change the row and column page sizes independently at runtime. Furthermore, toggle the position of the row and column pagers, modify their visibility, and visualize them using a compact view mode.

Paging in Blazor Pivot Table component.

Optimized for mobile devices

Touch support for Blazor Pivot Table component.

Touch support

All features will work on touch devices. Features such as drill up and down, filtering, sorting, and report manipulation can be done on the fly.

Responsive view of Blazor Pivot Table component.


Responsive support allows the component layout to be viewed on various devices.

Field list support in Blazor Pivot Table component to create reports dynamically at runtime.

Adaptable field list UI

The Pivot Table field list can be displayed on various devices in a presentable manner.

Blazor Pivot Table component along with field list and grouping bar.

Pivot table field list and group fields

The Blazor Pivot Table field list and group fields options 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 up

Use 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.

Blazor Pivot Table with drill up and drill down support.

Blazor Pivot Table with defer layout update support.

Defer layout update

Users can refresh the component on demand instead of during every UI interaction in the Blazor Pivot Table.

Editing and updating

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 Blazor Pivot Table component supports various edit modes such as inline, dialog, batch edit, and column edit through an interactive UI.

Blazor Pivot Table with editing and updating support.


Built-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 Blazor Pivot Table.

Blazor Pivot Table normal filter.

Header filtering

Display only selective values for a field. This can be achieved either through UI or code-behind.

Blazor Pivot Table label filtering.

Label filtering

Use Excel-like filtering options across column and row headers based on label text, date, or number.

Blazor Pivot Table value filtering.

Value filtering

Use Excel-like filtering options across column and row headers based on grand total values.


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

Normal sorting in ascending and descending order using Blazor Pivot Table.

Header sorting

Order the column and row header text either in ascending or descending order.

Column sorting in ascending and descending order using Blazor Pivot Table.

Column sorting

Column 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.

Aggregation support in Blazor Pivot Table component.


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 standard deviation, sample standard deviation, population variance, sample variance, running totals, difference from, percent of difference from, and percent of grand total.

Calculated field

The calculated field, otherwise known as the unbound field, generates a unique field with the user’s own calculated values by executing a simple user-defined formula.

Calculated field, user-defined field in Blazor Pivot Table component.

Blazor Pivot Table with drill through.

Drill through

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.

Blazor Pivot Table component totals.

Conditional formatting support in Blazor Pivot Table component.

Conditional formatting

Users can define conditions that, when met, format font style, text color, background color, and font size for values and summary cells.

Number and date formatting

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

Number and date formatting in Blazor Pivot Table component.

Pivot Table and grouping date and number.

Grouping date and number

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.

Frozen header

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

Freeze row and column headers in Blazor Pivot Table component.

Columns and rows

Resizes columns in Pivot Table component.


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.

Reorders columns in Blazor Pivot Table component.


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.

Hyperlink in Blazor Pivot Table component.

Users can retrieve information about a particular cell on clicking a hyperlink cell. It later allows them to perform custom operations programmatically.

Cell selection in Blazor Pivot Table component.

Cell selection

Select a range of cells.

Tooltip in Blazor Pivot Table component.


A tooltip provides basic information about a cell when hovering over it.

Cell template support in Blazor Pivot Table component.

Cell template

With cell templates, users can add features like images, checkboxes, and text nodes to any cell with ease.

Toolbar option in Blazor Pivot Table component.


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 header, footer, and cell properties like type, style, and position programmatically.

Exports reports to Excel, PDF, and CSV in Blazor Pivot Table component.

Custom style and theme

Built-in theme support in Blazor pivot table component

Built-in themes

Ships with several stunning, built-in themes: Tailwind CSS, Bootstrap 5, Bootstrap 4, Bootstrap, Material, Fabric, and High Contrast.

Custom CSS for Blazor Pivot Table control.

Custom styling

You can customize the appearance of the component to any extent programmatically.

Globalization and localization

Globalization support in Blazor Pivot Table control.


Users from different locales can use the component by formatting the date, currency, and numbering to suit locale preferences. The component uses an internalization (i18n) library for handling value formatting.

Right to left, RTL, support in Blazor Pivot Table component.

Right to left (RTL)

Supports right-to-left rendering and allows the text direction and layout of the component to be displayed from right to left.

Localization support in Blazor Pivot Table component.


You can localize all the component strings in the user interface as needed and use the localization (l10n) library to localize UI strings.

Developer-friendly API

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.

Blazor Pivot Table supports many browsers.

Cross-browser compatibility

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, Edge, Safari, and Opera browsers.

Blazor Pivot Table code example

Easily get started with the Blazor Pivot Table using a few simple lines of C# code as demonstrated in the following. Also, explore our Blazor Pivot Table example, which shows you how to render and configure the Blazor Pivot Grid.

@using Syncfusion.Blazor.PivotView

<SfPivotView TValue="ProductDetails" Height="300">
     <PivotViewDataSourceSettings DataSource="@dataSource">
            <PivotViewColumn Name="Year"></PivotViewColumn>
            <PivotViewColumn Name="Quarter"></PivotViewColumn>
            <PivotViewRow Name="Country"></PivotViewRow>
            <PivotViewRow Name="Products"></PivotViewRow>
            <PivotViewValue Name="Sold" Caption="Units Sold"></PivotViewValue>
            <PivotViewValue Name="Amount" Caption="Sold Amount"></PivotViewValue>
            <PivotViewFormatSetting Name="Amount" Format="C"></PivotViewFormatSetting>

    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;

Other supported frameworks

Pivot Table is also available in Angular, React, Vue, and JavaScript frameworks, all built from their own TypeScript libraries. Check out the Pivot Table for different platforms from the links:

Blazor Components – 80+ UI and DataViz Components

Frequently Asked Questions

  • High performance pivot engine and virtualization that helps load large volumes of data quickly.
  • Supports both relational and OLAP data sources. The relational data source can use input data via Web API, OData, and more.
  • Organize and summarize pivot data in both table and chart.
  • Experience seamless interaction and editing capabilities (for relational data source) in both server-side and client-side (WebAssembly) Blazor apps.
  • One of the best Blazor Pivot Table in the market that offers feature-rich UI to interact with the software.
  • Simple configuration and API.
  • Supports all modern browsers.
  • Mobile-touch friendly and responsive.
  • Extensive demos, documentation and videos to learn quickly and get started with Blazor Pivot Table.

You can find our Blazor Pivot Table demo here.

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.

Our Customers Love Us

Having an excellent set of tools and a great support team, Syncfusion reduces customers’ development time.
Here are some of their experiences.

Rated by users across the globe

Transform your applications today by downloading our free evaluation version Download Free Trial


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.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile