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 |
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.
Get an email when new components and releases ship.
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
Premium Themes
Free Themes