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/grouping.md
View on GitHub# Grouping — Syncfusion Blazor Pivot Table
Grouping automatically organizes date, number, and string fields into meaningful categories (e.g., dates into Year/Quarter/Month, numbers into ranges). Grouped fields act as independent fields and can be moved between axes. Applies to **relational data sources only**.
## Table of Contents
- [Enable Grouping](#enable-grouping)
- [Number Grouping](#number-grouping)
- [Date Grouping](#date-grouping)
- [Custom Grouping](#custom-grouping)
- [Programmatic Grouping Configuration](#programmatic-grouping-configuration)
---
## Enable Grouping
Set `AllowGrouping="true"` on `SfPivotView`. Users can then right-click any row/column header in the Pivot Table and select **Group** or **Ungroup**.
```razor
@using Syncfusion.Blazor.PivotView
<SfPivotView TValue="ProductDetails" ShowGroupingBar="true" AllowGrouping="true">
<PivotViewDataSourceSettings DataSource="@data">
<PivotViewColumns>
<PivotViewColumn Name="Product_ID" Caption="Product ID"></PivotViewColumn>
</PivotViewColumns>
<PivotViewRows>
<PivotViewRow Name="Date" Caption="Date"></PivotViewRow>
</PivotViewRows>
<PivotViewValues>
<PivotViewValue Name="Sold" Caption="Units Sold"></PivotViewValue>
<PivotViewValue Name="Amount" Caption="Sold Amount"></PivotViewValue>
</PivotViewValues>
<PivotViewFormatSettings>
<PivotViewFormatSetting Name="Date" Type="FormatType.DateTime"
Format="dd/MM/yyyy-hh:mm">
</PivotViewFormatSetting>
<PivotViewFormatSetting Name="Amount" Format="C" UseGrouping="true">
</PivotViewFormatSetting>
</PivotViewFormatSettings>
</PivotViewDataSourceSettings>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
}
```
> Only **one type of grouping** can be applied to a single field at a time (similar to Excel behavior).
---
## Number Grouping
Groups numeric field members into ranges (e.g., Product IDs 1–5, 6–10).
**Via UI:** Right-click a numeric header → select **Group** → set start, end, and interval values.
**Programmatically:**
```razor
<PivotViewGroupSettings>
<PivotViewGroupSetting Name="Product_ID" GroupInterval="5"
StartingAt="1" EndingAt="200"
Type="GroupType.Number">
</PivotViewGroupSetting>
</PivotViewGroupSettings>
```
---
## Date Grouping
Groups a `DateTime` field into hierarchical levels such as Year, Quarter, Month, Day, Hours, Minutes, Seconds.
**Via UI:** Right-click a date/time header → **Group** → select desired intervals.
**Programmatically:**
```razor
<PivotViewGroupSettings>
<PivotViewGroupSetting Name="Date"
Type="GroupType.Date"
GroupByDate="@dateGroupSettings">
</PivotViewGroupSetting>
</PivotViewGroupSettings>
@code {
// Group by Year and Month
public DateGroup dateGroupSettings = new DateGroup
{
Years = true,
Months = true,
Quarters = false,
Days = false
};
}
```
**Available date group levels:** `Years`, `Quarters`, `Months`, `Days`, `Hours`, `Minutes`, `Seconds`
> **Tip:** Date grouping is the most common use case — group a date-of-order field by Year and Quarter to create time-series pivot reports without modifying the underlying data.
---
## Custom Grouping
Groups selected members of a field into a custom named category. For example, group "Mountain Bikes" and "Road Bikes" into "Bikes".
**Via UI:** Select specific row/column members using Ctrl+click → right-click → **Group** → enter a group name.
**Programmatically:**
```razor
<PivotViewGroupSettings>
<PivotViewGroupSetting Name="Products"
Type="GroupType.Custom"
CustomGroups="@customGroups">
</PivotViewGroupSetting>
</PivotViewGroupSettings>
@code {
List<CustomGroups> customGroups = new List<CustomGroups>
{
new CustomGroups
{
GroupName = "Bikes",
Items = new string[] { "Mountain Bikes", "Road Bikes" }
}
};
}
```
---
## Programmatic Grouping Configuration
Full example combining multiple settings:
```razor
<SfPivotView TValue="ProductDetails" AllowGrouping="true">
<PivotViewDataSourceSettings DataSource="@data">
<PivotViewColumns>
<PivotViewColumn Name="Date"></PivotViewColumn>
</PivotViewColumns>
<PivotViewRows>
<PivotViewRow Name="Product_ID"></PivotViewRow>
</PivotViewRows>
<PivotViewValues>
<PivotViewValue Name="Amount"></PivotViewValue>
</PivotViewValues>
<PivotViewFormatSettings>
<PivotViewFormatSetting Name="Date" Type="FormatType.DateTime"
Format="dd/MM/yyyy">
</PivotViewFormatSetting>
</PivotViewFormatSettings>
<PivotViewGroupSettings>
<!-- Group date by year and quarter -->
<PivotViewGroupSetting Name="Date" Type="GroupType.Date"
GroupByDate="@dateGroup">
</PivotViewGroupSetting>
<!-- Group Product IDs into ranges of 10 -->
<PivotViewGroupSetting Name="Product_ID" GroupInterval="10"
StartingAt="1" EndingAt="100" Type="GroupType.Number">
</PivotViewGroupSetting>
</PivotViewGroupSettings>
</PivotViewDataSourceSettings>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
DateGroup dateGroup = new DateGroup { Years = true, Quarters = true };
}
```
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 |