PivotDataGrid
The RadzenPivotDataGrid component allows you to create cross-tabulation tables for analyzing large datasets.
This example demonstrates full pivot table functionality with columns, rows, and aggregates.
Bottom
Product Category | Product |
Year: 2023 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Country: France |
Country: Germany |
Country: Brazil |
Country: Switzerland | ||||||||||||||
| Total Sales | Total Quantity | Average Unit Price | Average Discount | Total Sales | Total Quantity | Average Unit Price | Average Discount | Total Sales | Total Quantity | Average Unit Price | Average Discount | Total Sales | Total Quantity | Average Unit Price | Average Discount | ||
| Dairy Products | Queso Cabrales | ¤168.00 | Qty: 12 | ¤14.00 | 0.00 % | Qty: N/A | Qty: N/A | Qty: N/A | |||||||||
| Mozzarella di Giovanni | ¤174.00 | Qty: 5 | ¤34.80 | 0.00 % | Qty: N/A | Qty: N/A | Qty: N/A | ||||||||||
| Geitost | Qty: N/A | Qty: N/A | ¤47.50 | Qty: 25 | ¤2.00 | 5.00 % | Qty: N/A | ||||||||||
| Camembert Pierrot | Qty: N/A | Qty: N/A | ¤1,088.00 | Qty: 40 | ¤27.20 | 0.00 % | Qty: N/A | ||||||||||
| Gorgonzola Telino | Qty: N/A | Qty: N/A | ¤200.00 | Qty: 20 | ¤10.00 | 0.00 % | Qty: N/A | ||||||||||
| Grains/Cereals | Singaporean Hokkien Fried Mee | ¤98.00 | Qty: 10 | ¤9.80 | 0.00 % | Qty: N/A | Qty: N/A | Qty: N/A | |||||||||
| Gustaf's Knäckebröd | ¤95.76 | Qty: 6 | ¤16.80 | 5.00 % | Qty: N/A | Qty: N/A | Qty: N/A | ||||||||||
| Ravioli Angelo | ¤222.30 | Qty: 15 | ¤15.60 | 5.00 % | Qty: N/A | Qty: N/A | Qty: N/A | ||||||||||
| Produce | Tofu | Qty: N/A | ¤167.40 | Qty: 9 | ¤18.60 | 0.00 % | Qty: N/A | Qty: N/A | |||||||||
| Manjimup Dried Apples | Qty: N/A | ¤1,696.00 | Qty: 40 | ¤42.40 | 0.00 % | ¤1,261.40 | Qty: 35 | ¤42.40 | 15.00 % | Qty: N/A | |||||||
| Longlife Tofu | Qty: N/A | Qty: N/A | Qty: N/A | ¤168.00 | Qty: 21 | ¤8.00 | 0.00 % | ||||||||||
| Seafood | Jack's New England Clam Chowder | Qty: N/A | Qty: N/A | ¤77.00 | Qty: 10 | ¤7.70 | 0.00 % | Qty: N/A | |||||||||
| Condiments | Louisiana Fiery Hot Pepper Sauce | ¤336.00 | Qty: 20 | ¤16.80 | 0.00 % | Qty: N/A | ¤214.20 | Qty: 15 | ¤16.80 | 15.00 % | Qty: N/A | ||||||
| Confections | Sir Rodney's Marmalade | Qty: N/A | Qty: N/A | ¤2,462.40 | Qty: 40 | ¤64.80 | 5.00 % | Qty: N/A | |||||||||
| Maxilaku | Qty: N/A | Qty: N/A | ¤640.00 | Qty: 40 | ¤16.00 | 0.00 % | Qty: N/A | ||||||||||
| Beverages | Chartreuse verte | Qty: N/A | Qty: N/A | ¤604.80 | Qty: 42 | ¤14.40 | 0.00 % | Qty: N/A | |||||||||
| Guaraná Fantástica | Qty: N/A | Qty: N/A | Qty: N/A | ¤45.90 | Qty: 15 | ¤3.60 | 15.00 % | ||||||||||
| Meat/Poultry | Pâté chinois | Qty: N/A | Qty: N/A | Qty: N/A | ¤342.72 | Qty: 21 | ¤19.20 | 15.00 % | |||||||||
Radzen Blazor Components, © 2018-2025 Radzen.
Source Code licensed under
MIT