Syncfusion.AspNetCore.PivotView
34.1.31
Prefix Reserved
dotnet add package Syncfusion.AspNetCore.PivotView --version 34.1.31
NuGet\Install-Package Syncfusion.AspNetCore.PivotView -Version 34.1.31
<PackageReference Include="Syncfusion.AspNetCore.PivotView" Version="34.1.31" />
<PackageVersion Include="Syncfusion.AspNetCore.PivotView" Version="34.1.31" />
<PackageReference Include="Syncfusion.AspNetCore.PivotView" />
paket add Syncfusion.AspNetCore.PivotView --version 34.1.31
#r "nuget: Syncfusion.AspNetCore.PivotView, 34.1.31"
#:package Syncfusion.AspNetCore.PivotView@34.1.31
#addin nuget:?package=Syncfusion.AspNetCore.PivotView&version=34.1.31
#tool nuget:?package=Syncfusion.AspNetCore.PivotView&version=34.1.31
Syncfusion® ASP.NET Core Pivot Table Component
A powerful business intelligence tool for summarizing and analyzing large datasets using multi-dimensional cross-tabulation with support for OLAP and flat data sources.
Key Features
- Drag-and-Drop Configuration: Runtime field list for configuring rows, columns, values, and filters without coding
- Multiple Data Sources: Support for local JSON data, OLAP (SSAS), and remote data sources for flexible data binding
- Calculated Fields: Create custom fields and aggregations for advanced data analysis
- Pivot Chart Integration: Visual cross-tabulation with integrated pivot chart for data visualization
- Performance Optimization: Virtual scrolling, paging, and lazy loading for handling large datasets efficiently
- Conditional Formatting: Apply formatting rules to cells based on values for highlighting insights
- Export Capabilities: Export to PDF and Excel formats for reporting and sharing results
- Data Aggregation: Multiple aggregation types with value formatting options
- Cell Selection: Advanced cell selection and interaction capabilities
- Accessibility: Full keyboard navigation and screen reader support
Common Setup
1. Install NuGet Package
Install-Package Syncfusion.AspNetCore.PivotView
2. Register Tag Helper
Add to ~/Pages/_ViewImports.cshtml or ~/Views/_ViewImports.cshtml:
@addTagHelper *, Syncfusion.AspNetCore.PivotView
3. Add Stylesheet & Script References
In your layout file:
<head>
<link rel="stylesheet" href="_content/Syncfusion.AspNetCore.Themes/styles/fluent2.css" />
<script src="_content/Syncfusion.AspNetCore.PivotView/scripts/sf-pivotfieldlist.min.js"></script>
<script src="_content/Syncfusion.AspNetCore.PivotView/scripts/sf-pivotview.min.js"></script>
</head>
4. Register Script Manager
<ejs-scripts></ejs-scripts>
Quick Start
Step 1: ~/Pages/Index.cshtml.cs
public class IndexModel : PageModel
{
public List<SalesData> PivotData { get; set; }
public void OnGet()
{
PivotData = new List<SalesData>
{
new SalesData { ProductID = "Laptop", Country = "USA", Amount = 50000, Quantity = 25 },
new SalesData { ProductID = "Laptop", Country = "India", Amount = 35000, Quantity = 18 },
new SalesData { ProductID = "Mobile", Country = "USA", Amount = 30000, Quantity = 50 },
new SalesData { ProductID = "Mobile", Country = "India", Amount = 45000, Quantity = 60 },
new SalesData { ProductID = "Tablet", Country = "USA", Amount = 20000, Quantity = 15 },
new SalesData { ProductID = "Tablet", Country = "India", Amount = 18000, Quantity = 12 }
};
}
}
public class SalesData
{
public string ProductID { get; set; }
public string Country { get; set; }
public double Amount { get; set; }
public int Quantity { get; set; }
}
Step 2: ~/Pages/Index.cshtml
<ejs-pivotview id="PivotView" dataSource="@Model.PivotData" height="450">
<e-pivotview-rows>
<e-pivotview-row name="ProductID"></e-pivotview-row>
</e-pivotview-rows>
<e-pivotview-columns>
<e-pivotview-column name="Country"></e-pivotview-column>
</e-pivotview-columns>
<e-pivotview-values>
<e-pivotview-value name="Amount" type="Sum"></e-pivotview-value>
<e-pivotview-value name="Quantity" type="Sum"></e-pivotview-value>
</e-pivotview-values>
</ejs-pivotview>
Step 3: Run the Application
Press Ctrl+F5 to run the application in your browser.
Documentation
Support
License
This is a commercial product and requires a paid license for possession or use. Review the Syncfusion® EULA
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
Desktop: WinForms | WPF | WinUI
Learn more at www.syncfusion.com
sales@syncfusion.com | Toll Free: 1-888-9-DOTNET
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net10.0
- Newtonsoft.Json (>= 13.0.4)
- Syncfusion.AspNetCore.Base (>= 34.1.31)
- Syncfusion.AspNetCore.Buttons (>= 34.1.31)
- Syncfusion.AspNetCore.Calendars (>= 34.1.31)
- Syncfusion.AspNetCore.Charts (>= 34.1.31)
- Syncfusion.AspNetCore.DropDowns (>= 34.1.31)
- Syncfusion.AspNetCore.Grid (>= 34.1.31)
- Syncfusion.AspNetCore.Inputs (>= 34.1.31)
- Syncfusion.AspNetCore.Navigations (>= 34.1.31)
- Syncfusion.AspNetCore.Popups (>= 34.1.31)
- Syncfusion.AspNetCore.SplitButtons (>= 34.1.31)
- Syncfusion.Licensing (>= 34.1.31)
-
net8.0
- Newtonsoft.Json (>= 13.0.4)
- Syncfusion.AspNetCore.Base (>= 34.1.31)
- Syncfusion.AspNetCore.Buttons (>= 34.1.31)
- Syncfusion.AspNetCore.Calendars (>= 34.1.31)
- Syncfusion.AspNetCore.Charts (>= 34.1.31)
- Syncfusion.AspNetCore.DropDowns (>= 34.1.31)
- Syncfusion.AspNetCore.Grid (>= 34.1.31)
- Syncfusion.AspNetCore.Inputs (>= 34.1.31)
- Syncfusion.AspNetCore.Navigations (>= 34.1.31)
- Syncfusion.AspNetCore.Popups (>= 34.1.31)
- Syncfusion.AspNetCore.SplitButtons (>= 34.1.31)
- Syncfusion.Licensing (>= 34.1.31)
-
net9.0
- Newtonsoft.Json (>= 13.0.4)
- Syncfusion.AspNetCore.Base (>= 34.1.31)
- Syncfusion.AspNetCore.Buttons (>= 34.1.31)
- Syncfusion.AspNetCore.Calendars (>= 34.1.31)
- Syncfusion.AspNetCore.Charts (>= 34.1.31)
- Syncfusion.AspNetCore.DropDowns (>= 34.1.31)
- Syncfusion.AspNetCore.Grid (>= 34.1.31)
- Syncfusion.AspNetCore.Inputs (>= 34.1.31)
- Syncfusion.AspNetCore.Navigations (>= 34.1.31)
- Syncfusion.AspNetCore.Popups (>= 34.1.31)
- Syncfusion.AspNetCore.SplitButtons (>= 34.1.31)
- Syncfusion.Licensing (>= 34.1.31)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.