DataGrid crosstab data support
Display crosstab data in a Blazor DataGrid by pivoting rows into columns - summarize values across two dimensions, such as sales by product and month, in a single grid.
Year | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 |
|---|---|---|---|---|---|---|---|---|---|---|
| Company | Toms Spezialitäten | HILARION-Abastos | Hanari Carnes | Vins et alcools Chevalier | Ernst Handel | Suprêmes délices | Split Rail Beer & Ale | Blondesddsl père et fils | Victuailles en stock | Chop-suey Chinese |
| Amount | ¤1,863.40 | ¤1,119.90 | ¤3,257.80 | ¤1,100.20 | ¤4,483.40 | ¤6,438.80 | ¤4,867.40 | ¤2,596.00 | ¤815.60 | ¤625.20 |
Frequently asked questions
Can the DataGrid show a crosstab or pivot layout?
Yes - project each cross dimension into its own column and define those columns; for a full pivot UI with row and column groups, use the PivotDataGrid.
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