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 Black | 93 | $653.13 | 93 | $653.13 | 56 | $151.31 | 92 | $376.46 | 148 | $527.77 | 49 | $338.66 | |||||||||||
| Alex Brown | 28 | $176.07 | 28 | $176.07 | |||||||||||||||||||
| Alex Burton | 75 | $143.06 | 98 | $211.58 | 173 | $354.64 | 136 | $708.00 | 136 | $708.00 | 14 | $352.13 | |||||||||||
| Alex Fox | 25 | $290.43 | 25 | $290.43 | |||||||||||||||||||
| Alex Walker | 13 | $247.20 | 136 | $507.75 | 149 | $754.95 | |||||||||||||||||
| Alice Burton | 95 | $376.16 | 95 | $376.16 | 52 | $233.25 | 3 | $177.71 | 55 | $410.96 | 23 | $326.14 | |||||||||||
| Alice Cooper | 65 | $397.22 | 66 | $269.45 | 131 | $666.67 | 43 | $358.50 | 43 | $358.50 | 1 | $213.68 | |||||||||||
| Alice Douglas | 47 | $400.15 | 47 | $400.15 | |||||||||||||||||||
| Curtis Black | 52 | $382.90 | 52 | $382.90 | 59 | $233.27 | |||||||||||||||||
| Curtis Brown | 13 | $238.58 | 94 | $646.34 | 107 | $884.93 | 4 | $353.24 | 55 | $504.57 | 59 | $857.81 | 56 | $166.77 | |||||||||
| Curtis Fox | 11 | $404.53 | 71 | $265.30 | 82 | $669.83 | |||||||||||||||||
| Curtis Parker | 6 | $199.74 | 3 | $386.37 | 78 | $383.49 | 87 | $969.60 | 86 | $288.38 | 93 | $300.09 | 179 | $588.47 | |||||||||
| Curtis White | 165 | $518.10 | 165 | $518.10 | 96 | $305.02 | 96 | $305.02 | 90 | $194.00 | |||||||||||||
| Jack Black | 46 | $314.87 | 32 | $553.85 | 78 | $868.72 | 10 | $245.39 | 51 | $427.53 | 61 | $672.91 | 45 | $154.97 | |||||||||
| Jack Parker | 54 | $376.52 | 54 | $376.52 | |||||||||||||||||||
| Jack Simpson | 92 | $255.49 | 92 | $255.49 | 1 | $204.28 | 262 | $1,298.08 | |||||||||||||||
| Jack Walker | 57 | $292.63 | 57 | $292.63 | 163 | $518.06 | 68 | $584.20 | |||||||||||||||
| John Black | 57 | $399.94 | 35 | $179.71 | 86 | $326.36 | 178 | $906.00 | 12 | $267.09 | 12 | $267.09 | |||||||||||
| John Brown | 21 | $345.01 | 5 | $277.69 | 26 | $622.70 | 86 | $307.73 | 86 | $307.73 | |||||||||||||
| John Douglas | 69 | $281.35 | 63 | $253.95 | 132 | $535.30 | 10 | $311.19 | 10 | $311.19 | |||||||||||||
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.