PivotDataGrid dynamic data support
Build a Blazor pivot table over schema-less IDictionary<string, object> records from external APIs, configuring pivot fields at runtime without C# models.
- Top
- Bottom
- TopAndBottom
- Order Year
- Ship Country
- Category
- Product
- Total Sales
- Quantity
- Average Discount
- Average Unit Price
- Order Year
- Ship Country
- Category
- Product
- Total Sales
- Quantity
- Average Discount
- Average Unit Price
Category |
|---|
Product |
Order Year |
|---|
Ship Country |
Total Sales |
|---|
Quantity |
Average Discount |
Average Unit Price |
Category |
2023 | Total Sales | Quantity | Average Discount | Average Unit Price | |||
|---|---|---|---|---|---|---|---|---|
| Total Sales | Quantity | Average Discount | Average Unit Price | |||||
Dairy Products | ¤5.00 | 5 | 500.0 % | ¤5.00 | ¤5.00 | 5 | 500.0 % | ¤5.00 |
Grains/Cereals | ¤3.00 | 3 | 300.0 % | ¤3.00 | ¤3.00 | 3 | 300.0 % | ¤3.00 |
Produce | ¤4.00 | 4 | 400.0 % | ¤4.00 | ¤4.00 | 4 | 400.0 % | ¤4.00 |
Seafood | ¤1.00 | 1 | 100.0 % | ¤1.00 | ¤1.00 | 1 | 100.0 % | ¤1.00 |
Condiments | ¤2.00 | 2 | 200.0 % | ¤2.00 | ¤2.00 | 2 | 200.0 % | ¤2.00 |
Confections | ¤2.00 | 2 | 200.0 % | ¤2.00 | ¤2.00 | 2 | 200.0 % | ¤2.00 |
Beverages | ¤2.00 | 2 | 200.0 % | ¤2.00 | ¤2.00 | 2 | 200.0 % | ¤2.00 |
Meat/Poultry | ¤1.00 | 1 | 100.0 % | ¤1.00 | ¤1.00 | 1 | 100.0 % | ¤1.00 |
| ¤20.00 | 20 | 2,000.0 % | ¤20.00 | ¤249.00 | 249 | 24,900.0 % | ¤249.00 | |
Frequently asked questions
How do I bind the Pivot DataGrid to dynamic data?
Bind Data to records of IDictionary<string, object> and configure the row, column, and value fields at runtime, without a fixed model.
Related
Radzen Blazor Newsletter
Get an email when new components and releases ship.
Save Hours on Every Project
With Radzen Blazor subscription you get the full toolkit, including:
Dedicated support backed by proven expertise
Premium themes and theme editor
Ready-to-use UI blocks
Complete app templates
Visual design-time-experience
Radzen Blazor Components, © 2018-2026 Radzen.
Source Code licensed under
MIT
- DataGridkeyboard_arrow_down
- Data-bindingkeyboard_arrow_down
- Virtualizationkeyboard_arrow_down
- Columnskeyboard_arrow_down
- Filteringkeyboard_arrow_down
- Hierarchykeyboard_arrow_down
- Selectionkeyboard_arrow_down
- Sortingkeyboard_arrow_down
- Pagingkeyboard_arrow_down
- Groupingkeyboard_arrow_down
- Custom Headerkeyboard_arrow_down
- Save/Load settingskeyboard_arrow_down
- Drag & Dropkeyboard_arrow_down
- Data Visualization Updated keyboard_arrow_down
- Configurationkeyboard_arrow_down
- Area Chartkeyboard_arrow_down
- Bar Chartkeyboard_arrow_down
- Column Chartkeyboard_arrow_down
- Line Chartkeyboard_arrow_down
- Waterfall Chartkeyboard_arrow_down
- Part-to-Whole Chartskeyboard_arrow_down
- Scatter & Bubblekeyboard_arrow_down
- Financial Chartskeyboard_arrow_down
- Statistical & Interactivekeyboard_arrow_down
- Gaugeskeyboard_arrow_down
- Zoom & Navigationkeyboard_arrow_down
- Formskeyboard_arrow_down
- DropDownkeyboard_arrow_down
- HtmlEditorkeyboard_arrow_down
- Spreadsheet New keyboard_arrow_down
- PivotDataGridkeyboard_arrow_down
- Document Processing New keyboard_arrow_down
- Datakeyboard_arrow_down
- DataListkeyboard_arrow_down
- DataFilterkeyboard_arrow_down
- Ganttkeyboard_arrow_down
- Treekeyboard_arrow_down
- Navigationkeyboard_arrow_down
- Layoutkeyboard_arrow_down
- UI Fundamentalskeyboard_arrow_down
- App Templateskeyboard_arrow_down
- UI Blocks Prokeyboard_arrow_down
- Imageskeyboard_arrow_down
- Feedbackkeyboard_arrow_down
- Alertkeyboard_arrow_down
- Validatorskeyboard_arrow_down
Demos Configuration
Premium Themes
- Material 3
- Material 3 Dark
- Material 3 Expressive
- Material 3 Expressive Dark
- Fluent
- Fluent Dark
Free Themes
- Material
- Material Dark
- Standard
- Standard Dark
- Default
- Dark
- Humanistic
- Humanistic Dark
- Software
- Software Dark