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/drill-down.md
View on GitHub# Drill Down — Syncfusion Blazor Pivot Table
Drill down enables expanding and collapsing hierarchical members (e.g., Year → Quarter, Country → City) in row and column headers. Users can interactively explore data at different levels, and you can programmatically control expansion.
## Drill Down and Drill Up
When a field has hierarchical members, expand/collapse icons automatically appear on row and column headers. Click the **+** icon to drill down (expand children) and the **-** icon to drill up (collapse).
This feature is **built-in** and requires no additional configuration when multiple fields are placed on the same axis.
```razor
@using Syncfusion.Blazor.PivotView
<SfPivotView TValue="ProductDetails">
<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>
</PivotViewDataSourceSettings>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
}
```
## Expand All on Load
By default, only the top-level members are shown. Set `ExpandAll="true"` to show all levels expanded from the start:
```razor
<PivotViewDataSourceSettings DataSource="@data" ExpandAll="true">
```
> **Applies to:** Relational data sources only.
## Expand Specific Members on Load
Use `PivotViewDrilledMember` inside `PivotViewDataSourceSettings` to expand only specific members programmatically:
> **⚠️ `Name` Must Be the Field Name, Not a Member Value:**
>
> `PivotViewDrilledMember.Name` refers to the **field name** (the property/column name), not a member caption or a modified value like `"Year_FY2023"`. The members to expand go in `Items`.
```razor
<PivotViewDataSourceSettings DataSource="@data">
...
<PivotViewDrilledMembers>
<!-- Pre-expand "FY 2023" under Year column -->
<PivotViewDrilledMember Name="Year" Items="@(new string[] { "FY 2023" })">
</PivotViewDrilledMember>
<!-- Pre-expand "France" under Country row -->
<PivotViewDrilledMember Name="Country" Items="@(new string[] { "France" })">
</PivotViewDrilledMember>
</PivotViewDrilledMembers>
</PivotViewDataSourceSettings>
```
## Drill Position (Independent Drill)
Drilling down on a member in one position does not affect the same member name appearing elsewhere. For example, if both FY 2022 and FY 2023 have "Q1" as a child:
- Expanding Q1 under FY 2022 only expands that specific Q1
- Q1 under FY 2023 remains collapsed
This behavior is automatic and cannot be disabled — it ensures precise data focus.
## Responding to Drill Operations with Events
Use the `OnActionBegin` event to detect drill-down and drill-up actions before they execute, and optionally block them:
```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>
</PivotViewDataSourceSettings>
<PivotViewEvents TValue="ProductDetails" OnActionBegin="ActionBegin">
</PivotViewEvents>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
public void ActionBegin(PivotActionBeginEventArgs args)
{
if (args.ActionName == "Drill down")
{
// Handle drill down action
Console.WriteLine("User is drilling down");
// Optionally block the action
// args.Cancel = true;
}
else if (args.ActionName == "Drill up")
{
// Handle drill up action
Console.WriteLine("User is drilling up");
}
}
}
```
The `ActionName` parameter indicates the drill action:
- `"Drill down"` - User expanded a member
- `"Drill up"` - User collapsed a member
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 |