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/layout-and-display.md
View on GitHub# Layout & Display — Syncfusion Blazor Pivot Table
## Table of Contents
- [Width and Height](#width-and-height)
- [Classic (Tabular) Layout](#classic-tabular-layout)
- [Row & Column Customization](#row--column-customization)
- [Show or Hide Totals](#show-or-hide-totals)
- [Hyperlinks in Cells](#hyperlinks-in-cells)
- [Tooltip](#tooltip)
---
## Width and Height
Set dimensions using pixel values, percentages, or auto:
```razor
<!-- Fixed pixel size -->
<SfPivotView TValue="ProductDetails" Width="800" Height="400">
<!-- Responsive: fill container width -->
<SfPivotView TValue="ProductDetails" Width="100%" Height="500px">
<!-- Auto height: expands with content, parent scrolls -->
<SfPivotView TValue="ProductDetails" Width="100%" Height="auto">
```
> Minimum width is **400px** — values below this are ignored.
---
## Classic (Tabular) Layout
The default layout is **compact** (hierarchical, indented). The **classic/tabular layout** places each row field in its own separate column, resembling a flat table — useful for exporting or when users prefer Excel-style pivot views.
> **Limitation:** Classic layout works only with **relational** data sources and the **client-side engine**.
```razor
@using Syncfusion.Blazor.PivotView
<SfPivotView TValue="ProductDetails" Height="450" Width="100%">
<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>
<!-- Enable classic/tabular layout -->
<PivotViewGridSettings Layout="PivotLayout.Tabular"></PivotViewGridSettings>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
}
```
`PivotLayout` options:
- `PivotLayout.Compact` — default hierarchical view
- `PivotLayout.Tabular` — classic/tabular (each row field in its own column)
---
## Row & Column Customization
### Column width
```razor
<PivotViewGridSettings ColumnWidth="120"></PivotViewGridSettings>
```
### Freeze rows and columns (sticky headers)
```razor
<PivotViewGridSettings FrozenRows="2" FrozenColumns="1"></PivotViewGridSettings>
```
### Auto-fit columns
```razor
<PivotViewGridSettings AllowAutoResizing="true"></PivotViewGridSettings>
```
### Row height
```razor
<PivotViewGridSettings RowHeight="36"></PivotViewGridSettings>
```
---
## Show or Hide Totals
Control grand totals and sub-totals in `PivotViewDataSourceSettings`:
```razor
<!-- Hide all grand totals -->
<PivotViewDataSourceSettings DataSource="@data" ShowGrandTotals="false">
<!-- Hide only row grand totals -->
<PivotViewDataSourceSettings DataSource="@data" ShowRowGrandTotals="false">
<!-- Hide only column grand totals -->
<PivotViewDataSourceSettings DataSource="@data" ShowColumnGrandTotals="false">
<!-- Hide all sub-totals -->
<PivotViewDataSourceSettings DataSource="@data" ShowSubTotals="false">
<!-- Hide row sub-totals only -->
<PivotViewDataSourceSettings DataSource="@data" ShowRowSubTotals="false">
```
> All totals are shown by default (`true`). Hiding them reduces visual clutter in reports with many nested levels.
---
## Hyperlinks in Cells
Render cells as clickable hyperlinks and handle them via the `HyperlinkCellClick` event:
```razor
<SfPivotView TValue="ProductDetails">
<PivotViewDataSourceSettings DataSource="@data">
...
</PivotViewDataSourceSettings>
<!-- Enable hyperlinks on value cells only -->
<PivotViewHyperlinkSettings ShowValueCellHyperlink="true"
CssClass="e-custom-hyperlink">
</PivotViewHyperlinkSettings>
<PivotViewEvents TValue="ProductDetails"
HyperlinkCellClick="OnHyperlinkClick">
</PivotViewEvents>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
void OnHyperlinkClick(HyperCellClickEventArgs args)
{
// args.CurrentCell contains the clicked cell info
Console.WriteLine($"Clicked: {args.CurrentCell.Value}");
}
}
```
**`PivotViewHyperlinkSettings` properties:**
| Property | Purpose |
|---|---|
| `ShowHyperlink` | Enable links on all cells |
| `ShowRowHeaderHyperlink` | Links only on row headers |
| `ShowColumnHeaderHyperlink` | Links only on column headers |
| `ShowValueCellHyperlink` | Links only on value cells |
| `ShowSummaryCellHyperlink` | Links only on summary/total cells |
| `HeaderText` | Enable link on a specific header text value |
| `CssClass` | Custom CSS class for styling the links |
---
## Tooltip
Tooltips show contextual information (row/column headers + value) when hovering over value cells. Enabled by default.
```razor
<!-- Show tooltip (default: true) -->
<SfPivotView TValue="ProductDetails" ShowTooltip="true">
<!-- Disable tooltip for better performance on large datasets -->
<SfPivotView TValue="ProductDetails" ShowTooltip="false">
```
> **Performance tip:** Disable tooltips (`ShowTooltip="false"`) when using `EnableVirtualization="true"` — toggling the tooltip on large virtualized datasets can cause minor re-render overhead.
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 |