syncfusion/blazor-ui-components-skills / skills/syncfusion-blazor-pivot-table
syncfusion-blazor-pivot-table
VerifiedUse this skill when users ask how to implement Syncfusion Pivot Table/PivotView in Blazor. Trigger for Blazor components, data binding, OLAP analysis, aggregation, drill-down/drill-through, grouping, filtering, conditional formatting, exports (Excel/PDF/CSV), or pivot charts. Blazor-only, not React/Angular/Vue/JS.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 12.1 KB |
| references/aggregation.md | markdown | 5.0 KB |
| references/calculated-field.md | markdown | 5.8 KB |
| references/connecting-to-data-sources.md | markdown | 10.6 KB |
| references/data-binding.md | markdown | 14.1 KB |
| references/drill-down.md | markdown | 4.8 KB |
| references/drill-through.md | markdown | 1.1 KB |
| references/editing.md | markdown | 5.0 KB |
| references/excel-export.md | markdown | 3.1 KB |
| references/field-list.md | markdown | 6.0 KB |
| references/filtering.md | markdown | 4.9 KB |
| references/formatting.md | markdown | 5.6 KB |
| references/getting-started.md | markdown | 6.9 KB |
| references/grouping-bar.md | markdown | 4.2 KB |
| references/grouping.md | markdown | 5.6 KB |
| references/layout-and-display.md | markdown | 5.6 KB |
| references/olap.md | markdown | 22.6 KB |
| references/pdf-export.md | markdown | 2.3 KB |
| references/performance-best-practices.md | markdown | 12.3 KB |
| references/pivot-chart.md | markdown | 6.7 KB |
| references/smart-pivot.md | markdown | 7.3 KB |
| references/sorting.md | markdown | 4.0 KB |
| references/state-and-events.md | markdown | 7.1 KB |
| references/tool-bar.md | markdown | 6.4 KB |
references/aggregation.md
View on GitHub# Aggregation — Syncfusion Blazor Pivot Table
Aggregation determines how numeric values are summarized in Pivot Table cells. By default, values are summed. You can configure per-field aggregation types both programmatically and interactively via the Field List or Grouping Bar.
> **Note:** Aggregation applies to relational data sources only. String, boolean, and date fields support only `Count` and `DistinctCount`.
## Table of Contents
- [Available Aggregation Types](#available-aggregation-types)
- [Setting Aggregation Programmatically](#setting-aggregation-programmatically)
- [DifferenceFrom and PercentageOfDifferenceFrom](#differencefrom-and-percentageofdifferencefrom)
- [PercentageOfParentTotal](#percentageofparenttotal)
- [Changing Aggregation at Runtime via UI](#changing-aggregation-at-runtime-via-ui)
---
## Available Aggregation Types
| `SummaryTypes` Value | Description |
|---|---|
| `Sum` | Total sum (default for numeric fields) |
| `Count` | Number of records |
| `DistinctCount` | Number of unique values |
| `Avg` | Arithmetic mean |
| `Median` | Middle value |
| `Min` | Minimum value |
| `Max` | Maximum value |
| `Product` | Product of all values |
| `Index` | Cell index relative to grand total |
| `RunningTotals` | Cumulative running total |
| `PercentageOfRunningTotals` | Cumulative percentage of running totals (client-side engine only) |
| `PopulationStDev` | Population standard deviation |
| `SampleStDev` | Sample standard deviation |
| `PopulationVar` | Population variance |
| `SampleVar` | Sample variance |
| `DifferenceFrom` | Difference from a base item in a base field |
| `PercentageOfDifferenceFrom` | % difference from a base item |
| `PercentageOfGrandTotal` | % of grand total |
| `PercentageOfColumnTotal` | % of column total |
| `PercentageOfRowTotal` | % of row total |
| `PercentageOfParentTotal` | % of parent total based on a base field |
| `PercentageOfParentColumnTotal` | % of parent column total |
| `PercentageOfParentRowTotal` | % of parent row total |
| `CalculatedField` | Marks the field as a custom calculated field |
---
## Setting Aggregation Programmatically
Set the `Type` property on `PivotViewValue` using `SummaryTypes`:
```razor
@using Syncfusion.Blazor.PivotView
<SfPivotView TValue="ProductDetails">
<PivotViewDataSourceSettings DataSource="@data">
<PivotViewColumns>
<PivotViewColumn Name="Year"></PivotViewColumn>
</PivotViewColumns>
<PivotViewRows>
<PivotViewRow Name="Country"></PivotViewRow>
<PivotViewRow Name="Products"></PivotViewRow>
</PivotViewRows>
<PivotViewValues>
<!-- Default: Sum -->
<PivotViewValue Name="Sold" Caption="Units Sold"
Type="SummaryTypes.Sum"></PivotViewValue>
<!-- Average amount -->
<PivotViewValue Name="Amount" Caption="Avg Amount"
Type="SummaryTypes.Avg"></PivotViewValue>
<!-- % of grand total -->
<PivotViewValue Name="Sold" Caption="% of Total"
Type="SummaryTypes.PercentageOfGrandTotal"></PivotViewValue>
</PivotViewValues>
</PivotViewDataSourceSettings>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
}
```
---
## DifferenceFrom and PercentageOfDifferenceFrom
These types compare each cell value to a specific member in a base field. Configure `BaseField` and `BaseItem`:
```razor
<PivotViewValues>
<PivotViewValue Name="Amount" Caption="Diff from FY 2022"
Type="SummaryTypes.DifferenceFrom"
BaseField="Year"
BaseItem="FY 2022">
</PivotViewValue>
<PivotViewValue Name="Amount" Caption="% Diff from FY 2022"
Type="SummaryTypes.PercentageOfDifferenceFrom"
BaseField="Year"
BaseItem="FY 2022">
</PivotViewValue>
</PivotViewValues>
```
> **Use case:** Show year-over-year growth by comparing each year's revenue against the baseline year.
---
## PercentageOfParentTotal
Shows each cell as a percentage of its parent total. Use `BaseField` to specify which parent field:
```razor
<PivotViewValues>
<PivotViewValue Name="Sold" Caption="% of Country Total"
Type="SummaryTypes.PercentageOfParentTotal"
BaseField="Country">
</PivotViewValue>
</PivotViewValues>
```
---
## Changing Aggregation at Runtime via UI
When `ShowGroupingBar="true"` or `ShowFieldList="true"`, users can change the aggregation type by clicking the value type icon (Σ) on a value field chip. A dropdown appears with all available `SummaryTypes`.
To allow this, no extra configuration is needed — it's enabled by default when the grouping bar or field list is visible.
To hide the aggregation type icon:
```razor
<PivotViewGroupingBarSettings ShowValueTypeIcon="false">
</PivotViewGroupingBarSettings>
```
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |