Quantity Unit Price |
Year Quarter Month | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Product Name | Sales Person Name | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Q1 Total | Q2 Total | ||||||||||||||||||||||
| January | February | March | April | May | June | July | August | ||||||||||||||||
| Quantity | Unit Price | Quantity | Unit Price | Quantity | Unit Price | Quantity | Unit Price | Quantity | Unit Price | Quantity | Unit Price | Quantity | Unit Price | Quantity | Unit Price | Quantity | Unit Price | Quantity | Unit Price | ||||
| Alex Cooper | 15 | $342.48 | 15 | $342.48 | 190 | $377.66 | 78 | $345.22 | 268 | $722.89 | 12 | $274.83 | |||||||||||
| Alex Hunter | 191 | $286.04 | 191 | $286.04 | 45 | $182.91 | 45 | $182.91 | 62 | $379.75 | |||||||||||||
| Alex Walker | 74 | $237.67 | 74 | $237.67 | |||||||||||||||||||
| Alice Brown | 68 | $370.77 | 68 | $370.77 | 13 | $239.56 | 53 | $363.33 | 66 | $602.89 | 158 | $434.62 | |||||||||||
| Alice Douglas | 52 | $272.43 | 27 | $131.62 | 79 | $404.05 | 84 | $385.98 | 84 | $385.98 | 88 | $331.92 | |||||||||||
| Alice Parker | 67 | $247.44 | 67 | $247.44 | 84 | $572.24 | 34 | $150.43 | 118 | $722.67 | |||||||||||||
| Alice Simpson | 56 | $192.27 | 56 | $192.27 | 11 | $278.64 | |||||||||||||||||
| Curtis Fox | 315 | $996.08 | 315 | $996.08 | |||||||||||||||||||
| Curtis Hunter | 38 | $201.11 | 74 | $237.71 | 112 | $438.82 | 53 | $263.83 | |||||||||||||||
| Curtis Simpson | 70 | $367.36 | 64 | $327.92 | 134 | $695.28 | |||||||||||||||||
| Curtis Walker | 64 | $300.04 | 64 | $300.04 | 44 | $344.77 | |||||||||||||||||
| Curtis White | 68 | $383.13 | 68 | $383.13 | 106 | $487.45 | 106 | $487.45 | 25 | $170.26 | |||||||||||||
| Jack Burton | 29 | $298.72 | 29 | $298.72 | |||||||||||||||||||
| Jack Cooper | 59 | $214.51 | 17 | $141.91 | 97 | $151.63 | 173 | $508.06 | 19 | $182.97 | 19 | $182.97 | 21 | $354.75 | |||||||||
| Jack Fox | 66 | $324.06 | 66 | $324.06 | 76 | $169.81 | |||||||||||||||||
| Jack Parker | 60 | $752.12 | 60 | $752.12 | 100 | $537.41 | |||||||||||||||||
| Jack Simpson | 144 | $618.67 | 124 | $530.72 | 268 | $1,149.40 | 90 | $162.13 | |||||||||||||||
| Jack Smith | 97 | $262.00 | 97 | $262.00 | 39 | $497.29 | 95 | $371.17 | 134 | $868.46 | 19 | $234.97 | |||||||||||
| John Brown | 124 | $654.90 | 124 | $654.90 | 68 | $642.89 | 27 | $141.27 | 173 | $774.60 | 268 | $1,558.76 | |||||||||||
| Julia Black | 52 | $235.38 | 52 | $235.38 | 58 | $758.56 | 58 | $758.56 | |||||||||||||||
The DevExpress Blazor Pivot Table component can display and analyze multi-dimensional data with absolute ease. In this demo, our Pivot Table is bound to a local data collection with 100,000 records. The Pivot Table leverages its built-in virtual scrolling mode to maximize overall performance. You can click the Refresh button to generate a new dataset and assign it to the Pivot Table.
To replicate this sample, you must:
- Bind the Data property to a C# field/property.
- Handle the
OnInitialized/OnInitializedAsynclifecycle method. In the event handler, populate this field/property with an IListSource or IEnumerable dataset. - Add fields to the component.