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 | 59 | $511.55 | 59 | $511.55 | 97 | $232.27 | 97 | $232.27 | 106 | $856.58 | |||||||||||||
| Alex Burton | 81 | $249.03 | 81 | $249.03 | 90 | $228.61 | |||||||||||||||||
| Alex Hunter | 176 | $525.99 | 50 | $440.96 | 226 | $966.95 | 98 | $802.56 | 94 | $301.49 | 122 | $753.41 | 314 | $1,857.45 | 65 | $426.28 | |||||||
| Alex Simpson | 95 | $281.45 | 75 | $301.46 | 170 | $582.90 | 52 | $322.01 | 52 | $322.01 | 17 | $174.57 | 59 | $311.11 | |||||||||
| Alex Smith | 51 | $421.82 | 1 | $419.30 | 12 | $220.45 | 64 | $1,061.56 | 47 | $712.66 | 26 | $469.48 | 73 | $1,182.14 | 102 | $736.85 | |||||||
| Alex White | |||||||||||||||||||||||
| Alice Parker | 79 | $182.41 | 79 | $182.41 | 50 | $246.85 | 66 | $412.02 | 116 | $658.86 | 7 | $391.86 | |||||||||||
| Alice Smith | 15 | $385.83 | 15 | $385.83 | |||||||||||||||||||
| Alice White | 108 | $476.32 | 95 | $919.27 | 97 | $714.51 | 300 | $2,110.09 | 96 | $444.46 | 72 | $202.20 | 168 | $646.66 | 65 | $254.94 | 91 | $696.44 | |||||
| Curtis Smith | 52 | $499.60 | 52 | $499.60 | |||||||||||||||||||
| Jack Burton | 119 | $478.85 | 119 | $478.85 | |||||||||||||||||||
| Jack Cooper | 63 | $474.13 | 47 | $224.63 | 110 | $698.76 | 22 | $472.99 | 22 | $472.99 | |||||||||||||
| Jack Fox | 95 | $471.80 | 61 | $363.87 | 156 | $835.67 | 171 | $581.11 | 12 | $235.05 | 183 | $816.15 | 164 | $1,320.71 | |||||||||
| Jack Hunter | 138 | $811.05 | 138 | $811.05 | 77 | $197.16 | 49 | $449.61 | 126 | $646.77 | 97 | $448.88 | 56 | $435.13 | |||||||||
| Jack Parker | 131 | $1,257.01 | 131 | $1,257.01 | 47 | $173.91 | 35 | $483.36 | 50 | $375.08 | 132 | $1,032.35 | |||||||||||
| Jack Smith | 96 | $442.30 | 96 | $442.30 | 130 | $477.28 | |||||||||||||||||
| Jack Walker | 65 | $399.84 | 75 | $299.70 | 140 | $699.55 | 9 | $213.81 | |||||||||||||||
| John Brown | 27 | $303.53 | 81 | $338.01 | 108 | $641.54 | 132 | $507.66 | 132 | $507.66 | 138 | $491.51 | |||||||||||
| John Burton | 9 | $193.22 | 9 | $193.22 | 93 | $385.94 | 50 | $260.80 | |||||||||||||||
| John Cooper | 42 | $250.52 | 42 | $250.52 | 39 | $278.79 | 39 | $278.79 | 54 | $281.23 | 9 | $196.94 | |||||||||||
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.