👁 Image
Syncfusion.Blazor.PivotTable 33.2.13

Syncfusion® Blazor Pivot Table

Powerful data analysis and visualization component for Blazor applications. Organize, summarize, and analyze large datasets with interactive pivoting, drilling, filtering, sorting, and export capabilities.

👁 Blazor Pivot Table

Key features

• Data Summarization: Organize and summarize business data in cross-table format
• Drill Down/Up: Interactive hierarchical navigation through data dimensions
• Filtering & Sorting: Excel-like filtering and sorting with multiple criteria
• Built-in Aggregations: Sum, average, count, min, max, and custom aggregations
• Calculated Fields: Create custom calculated fields based on existing data
• Excel & PDF Export: Export pivot tables to Excel and PDF formats
• Virtualization: Handle large datasets efficiently with row and column virtualization
• Field List: Interactive field list for dynamic dimension and measure configuration
• Editing: In-place editing with real-time data updates

Add stylesheet and script references

• For Blazor Web App / Blazor Server App, add these to Components/App.razor or App.razor file.
• For Blazor WebAssembly App, add these to wwwroot/index.html file.

<link href="_content/Syncfusion.Blazor.Themes/bootstrap5.css" rel="stylesheet" />
<script src="_content/Syncfusion.Blazor.Core/scripts/syncfusion-blazor.min.js" type="text/javascript"></script>

Quick start

1. Register the Syncfusion® Blazor service in the Program.cs file.

using Syncfusion.Blazor;

builder.Services.AddSyncfusionBlazor();

2. Add Blazor Pivot Table component to your Razor page.

@using Syncfusion.Blazor.PivotView

<SfPivotView TValue="ProductSalesData">
 <PivotViewDataSourceSettings DataSource="@Data">
 <PivotViewColumns>
 <PivotViewColumn Name="Year"></PivotViewColumn>
 </PivotViewColumns>
 <PivotViewRows>
 <PivotViewRow Name="Country"></PivotViewRow>
 </PivotViewRows>
 <PivotViewValues>
 <PivotViewValue Name="Sold" Type="SummaryTypes.Sum"></PivotViewValue>
 </PivotViewValues>
 </PivotViewDataSourceSettings>
</SfPivotView>

@code {
 private List<ProductSalesData> Data { get; set; }

 protected override void OnInitialized()
 {
 Data = new List<ProductSalesData>
 {
 new ProductSalesData { Country = "Canada", Year = "2024", Sold = 400 },
 new ProductSalesData { Country = "France", Year = "2024", Sold = 375 },
 new ProductSalesData { Country = "China", Year = "2024", Sold = 588 },
 new ProductSalesData { Country = "Canada", Year = "2025", Sold = 461 },
 new ProductSalesData { Country = "France", Year = "2025", Sold = 226 }
 };
 }

 public class ProductSalesData
 {
 public string Country { get; set; }
 public string Year { get; set; }
 public double Sold { get; set; }
 }
}

Documentation

• Getting Started with Blazor Web App
• Getting Started with WebAssembly
• API Reference
• Live Demos
• Feature Overview

Support

• Submit a support ticket
• Community forums
• Feature requests

License

This is a commercial product and requires a paid license for possession or use. Review the Syncfusion® EULA.

• Purchase a license
• Start a free 30-day trial

About Syncfusion®

Syncfusion® provides 1600+ UI components and frameworks for web, mobile, and desktop development across multiple platforms:

Web: Blazor | ASP.NET Core | ASP.NET MVC | JavaScript | Angular | React | Vue

Mobile: Flutter | MAUI | UWP

Desktop: WinForms | WPF | WinUI

Learn more at www.syncfusion.com.

| Toll Free: 1-888-9-DOTNET