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/formatting.md
View on GitHub# Formatting — Syncfusion Blazor Pivot Table
## Table of Contents
- [Number Formatting](#number-formatting)
- [Number Formatting via Toolbar at Runtime](#number-formatting-via-toolbar-at-runtime)
- [Conditional Formatting](#conditional-formatting)
- [Conditional Formatting via Toolbar at Runtime](#conditional-formatting-via-toolbar-at-runtime)
---
## Number Formatting
Format how numeric values display in cells using `PivotViewFormatSettings` inside `PivotViewDataSourceSettings`. Apply one format setting per value field.
### Format codes
| Code | Example Output | Usage |
|---|---|---|
| `C` / `C2` | $1,234.56 | Currency (2 decimal places) |
| `C0` | $1,235 | Currency, no decimals |
| `N` / `N2` | 1,234.56 | Number with grouping |
| `P` / `P2` | 12.34% | Percentage |
| `#,##0.00` | 1,234.56 | Custom pattern |
```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>
<PivotViewValue Name="Sold" Caption="Units Sold"></PivotViewValue>
<PivotViewValue Name="Amount" Caption="Sold Amount"></PivotViewValue>
</PivotViewValues>
<PivotViewFormatSettings>
<!-- Currency with thousand separators -->
<PivotViewFormatSetting Name="Amount" Format="C0" UseGrouping="true">
</PivotViewFormatSetting>
<!-- Plain number, 2 decimal places -->
<PivotViewFormatSetting Name="Sold" Format="N2">
</PivotViewFormatSetting>
</PivotViewFormatSettings>
</PivotViewDataSourceSettings>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
}
```
### Key `PivotViewFormatSetting` properties
| Property | Purpose |
|---|---|
| `Name` | Field name to format (must match `PivotViewValue Name`) |
| `Format` | Format string (C, N, P, or custom pattern) |
| `UseGrouping` | Show thousand separators (default: `true`) |
| `Currency` | Currency code (e.g., "USD", "EUR", "GBP") |
| `MinimumFractionDigits` | Minimum decimal places |
| `MaximumFractionDigits` | Maximum decimal places |
### Custom format example
```razor
<!-- Show as "1,234.56 USD" -->
<PivotViewFormatSetting Name="Amount" Format="#,##0.00" Currency="USD">
</PivotViewFormatSetting>
```
---
## Number Formatting via Toolbar at Runtime
Enable number formatting through the toolbar to let users change formats interactively:
```razor
<SfPivotView TValue="ProductDetails" ShowToolbar="true"
Toolbar="@toolbar" AllowNumberFormatting="true">
@code {
public List<ToolbarItems> toolbar = new List<ToolbarItems>
{
ToolbarItems.NumberFormatting
};
}
```
---
## Conditional Formatting
Apply CSS-style formatting (background color, font color, font size, font family) to value cells that meet specified conditions. This helps highlight key data points visually.
### Programmatic configuration
Use `PivotViewConditionalFormatSettings`:
```razor
<SfPivotView TValue="ProductDetails" AllowConditionalFormatting="true">
<PivotViewDataSourceSettings DataSource="@data">
...
</PivotViewDataSourceSettings>
<PivotViewConditionalFormatSettings>
<!-- Highlight Amount cells > 100000 in green -->
<PivotViewConditionalFormatSetting
Measure="Amount"
Conditions="Condition.GreaterThan"
Value1="100000"
Style="@highStyle">
</PivotViewConditionalFormatSetting>
<!-- Highlight Amount cells < 10000 in red -->
<PivotViewConditionalFormatSetting
Measure="Amount"
Conditions="Condition.LessThan"
Value1="10000"
Style="@lowStyle">
</PivotViewConditionalFormatSetting>
</PivotViewConditionalFormatSettings>
</SfPivotView>
@code {
public List<ProductDetails> data { get; set; }
protected override void OnInitialized() => data = ProductDetails.GetProductData().ToList();
PivotViewStyle highStyle = new PivotViewStyle
{
BackgroundColor = "#9ef59e", // light green
Color = "#004d00", // dark green text
FontSize = "14px",
FontFamily = "Segoe UI"
};
PivotViewStyle lowStyle = new PivotViewStyle
{
BackgroundColor = "#f5a59e", // light red
Color = "#4d0000", // dark red text
FontSize = "14px",
FontFamily = "Segoe UI"
};
}
```
**`PivotViewConditionalFormatSetting` properties:**
| Property | Purpose |
|---|---|
| `Measure` | Value field name the condition applies to |
| `Conditions` | Comparison (`GreaterThan`, `LessThan`, `Equals`, `Between`, etc.) |
| `Value1` | First threshold value |
| `Value2` | Second value (for `Between` condition) |
| `Style` | `PivotViewStyle` object with CSS properties |
| `ApplyGrandTotals` | Apply formatting to grand total cells too |
---
## Conditional Formatting via Toolbar at Runtime
```razor
<SfPivotView TValue="ProductDetails" ShowToolbar="true"
Toolbar="@toolbar" AllowConditionalFormatting="true">
@code {
public List<ToolbarItems> toolbar = new List<ToolbarItems>
{
ToolbarItems.ConditionalFormatting
};
}
```
Users click the **Conditional Formatting** toolbar icon to open an interactive dialog where they can create, edit, and delete formatting rules without code.
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 |