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-bar.md
View on GitHub# Grouping Bar — Syncfusion Blazor Pivot Table
The Grouping Bar is a drag-and-drop UI element rendered above the Pivot Table that displays the currently applied row, column, value, and filter fields. Users can rearrange, remove, filter, and sort fields interactively at runtime without needing to write code.
## Table of Contents
- [Enable Grouping Bar](#enable-grouping-bar)
- [What Users Can Do in the Grouping Bar](#what-users-can-do-in-the-grouping-bar)
- [Customizing Grouping Bar Behavior](#customizing-grouping-bar-behavior)
- [Show/Hide Specific Buttons](#showhide-specific-buttons)
- [Grouping Bar with Field List](#grouping-bar-with-field-list)
---
## Enable Grouping Bar
Set `ShowGroupingBar="true"` on `SfPivotView`:
```razor
@using Syncfusion.Blazor.PivotView
<SfPivotView TValue="ProductDetails" ShowGroupingBar="true">
<PivotViewDataSourceSettings DataSource="@data">
<PivotViewColumns>
<PivotViewColumn Name="Year"></PivotViewColumn>
<PivotViewColumn Name="Quarter"></PivotViewColumn>
</PivotViewColumns>
<PivotViewRows>
<PivotViewRow Name="Country"></PivotViewRow>
<PivotViewRow Name="Products"></PivotViewRow>
</PivotViewRows>
<PivotViewValues>
<PivotViewValue Name="Sold" Caption="Units Sold"></PivotViewValue>
<PivotViewValue Name="Amount" Caption="Sold Amount"></PivotViewValue>
</PivotViewValues>
<PivotViewFormatSettings>
<PivotViewFormatSetting Name="Amount" Format="C"></PivotViewFormatSetting>
</PivotViewFormatSettings>
</PivotViewDataSourceSettings>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
}
```
---
## What Users Can Do in the Grouping Bar
| Interaction | How |
|---|---|
| Rearrange fields | Drag chips between row/column/value/filter drop zones |
| Remove a field | Click the **×** (remove) icon on a field chip |
| Add a field | Click **Fields** icon to open field panel, then drag to a zone |
| Filter field members | Click the **filter** icon on a field chip |
| Sort field members | Click the **sort** icon on a field chip (ascending/descending) |
| Change aggregation type | Click the **aggregation** icon on a value field chip |
---
## Customizing Grouping Bar Behavior
Use `PivotViewGroupingBarSettings` inside `SfPivotView` to control which UI features are available:
```razor
<SfPivotView TValue="ProductDetails" ShowGroupingBar="true">
<PivotViewDataSourceSettings DataSource="@data">
...
</PivotViewDataSourceSettings>
<PivotViewGroupingBarSettings
ShowFilterIcon="true"
ShowSortIcon="true"
ShowRemoveIcon="true"
ShowValueTypeIcon="true"
AllowDragAndDrop="true">
</PivotViewGroupingBarSettings>
</SfPivotView>
```
| Property | Default | Purpose |
|---|---|---|
| `ShowFilterIcon` | `true` | Show filter icon on each field chip |
| `ShowSortIcon` | `true` | Show sort icon on each field chip |
| `ShowRemoveIcon` | `true` | Show remove (×) icon on each field chip |
| `ShowValueTypeIcon` | `true` | Show aggregation type icon on value field chips |
| `AllowDragAndDrop` | `true` | Allow fields to be dragged between axes |
---
## Show/Hide Specific Buttons
### Disable all sorting icons in the grouping bar
```razor
<PivotViewGroupingBarSettings ShowSortIcon="false">
</PivotViewGroupingBarSettings>
```
### Read-only grouping bar (no drag, no remove)
```razor
<PivotViewGroupingBarSettings
AllowDragAndDrop="false"
ShowRemoveIcon="false">
</PivotViewGroupingBarSettings>
```
---
## Grouping Bar with Field List
The grouping bar and field list work together seamlessly. When both are enabled, the Field List icon moves to the top-right corner of the grouping bar area:
```razor
<SfPivotView TValue="ProductDetails"
ShowGroupingBar="true"
ShowFieldList="true">
...
</SfPivotView>
```
> **Pattern:** Enable the grouping bar for users who primarily rearrange existing fields. Add the field list for users who need to add new fields from the data source. Both together give the full Excel-like pivot experience.
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 |