Large Data Source

Community Technology Preview (CTP)

 
2024 Total 2025 Total Grand Total
Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
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 Quantity Unit Price
Alex Brown 346 $519.05 116 $101.66 219 $350.35 109 $359.12 790 $1,330.19 311 $273.01 155 $214.66 74 $247.76 54 $121.20 594 $856.63 1384 $2,186.82
Alex Burton 73 $292.55 176 $286.64 66 $210.13 217 $351.66 532 $1,140.98 45 $46.87 75 $263.61 263 $452.47 92 $59.55 475 $822.50 1007 $1,963.49
Alex Fox 344 $475.62 59 $292.50 48 $68.89 223 $512.98 674 $1,349.99 247 $538.38 300 $497.25 149 $292.48 322 $405.20 1018 $1,733.30 1692 $3,083.29
Alex Parker 376 $495.50 236 $396.40 142 $228.27 754 $1,120.17 421 $459.44 98 $257.40 227 $665.03 167 $215.16 913 $1,597.03 1667 $2,717.20
Alex Simpson 96 $126.20 123 $130.51 105 $155.83 304 $499.35 628 $911.88 60 $228.55 467 $628.04 134 $202.18 421 $757.34 1082 $1,816.11 1710 $2,727.99
Alex White 245 $463.72 58 $67.07 46 $202.35 156 $204.75 505 $937.89 58 $169.49 170 $387.15 105 $287.44 333 $844.08 838 $1,781.98
Alice Cooper 85 $273.89 109 $415.26 249 $310.26 186 $264.07 629 $1,263.49 177 $264.36 60 $205.17 411 $706.36 97 $267.74 745 $1,443.63 1374 $2,707.11
Alice Fox 260 $419.72 280 $280.61 174 $302.58 96 $278.63 810 $1,281.53 63 $167.93 107 $233.37 107 $209.02 95 $69.87 372 $680.19 1182 $1,961.72
Alice Simpson 113 $229.57 7 $82.81 228 $423.43 133 $209.84 481 $945.65 162 $516.78 114 $204.10 182 $323.86 117 $264.66 575 $1,309.39 1056 $2,255.04
Curtis Black 156 $200.48 169 $153.59 104 $180.14 187 $365.51 616 $899.71 179 $192.17 110 $196.75 122 $174.39 314 $406.96 725 $970.27 1341 $1,869.98
Curtis Brown 317 $377.00 281 $541.67 311 $337.57 103 $130.24 1012 $1,386.47 172 $281.39 11 $123.54 52 $208.88 235 $613.82 1247 $2,000.29
Curtis Burton 179 $185.41 192 $272.40 270 $249.36 180 $479.97 821 $1,187.14 75 $206.39 215 $307.95 68 $77.88 67 $134.48 425 $726.71 1246 $1,913.85
Curtis Parker 64 $128.13 201 $295.81 293 $370.09 282 $471.19 840 $1,265.21 157 $316.46 50 $99.72 200 $274.22 400 $569.24 807 $1,259.64 1647 $2,524.86
Curtis White 203 $488.54 80 $506.35 645 $898.86 928 $1,893.75 115 $167.49 185 $129.48 210 $367.23 196 $303.35 706 $967.55 1634 $2,861.30
Jack Cooper 16 $90.92 332 $425.91 161 $190.65 509 $707.48 294 $269.34 177 $374.47 101 $401.38 139 $313.17 711 $1,358.36 1220 $2,065.85
Jack Douglas 102 $195.08 69 $82.45 254 $432.50 256 $480.61 681 $1,190.62 139 $237.85 32 $115.80 164 $321.14 20 $63.09 355 $737.88 1036 $1,928.51
Jack Parker 25 $54.18 112 $211.42 113 $257.94 250 $523.54 354 $625.80 143 $234.65 78 $249.80 366 $715.65 941 $1,825.90 1191 $2,349.44
John Black 91 $118.20 112 $241.72 116 $343.59 191 $362.44 510 $1,065.95 149 $134.94 276 $443.01 221 $298.39 646 $876.34 1156 $1,942.29
John Cooper 68 $203.15 136 $422.54 203 $248.13 407 $873.82 154 $306.75 196 $411.08 167 $252.58 15 $80.00 532 $1,050.41 939 $1,924.23
John Douglas 309 $858.57 90 $345.19 37 $220.00 436 $1,423.76 237 $583.56 206 $301.50 118 $292.94 288 $365.62 849 $1,543.62 1285 $2,967.38

This demo showcases the Pivot Table's performance with thousands of rows. The Pivot Table efficiently aggregates large data sources and allows users to navigate and sort data seamlessly.

Use the Pivot Table's virtual scrolling option to improve performance against large datasets. When the VirtualScrollingEnabled property is set to true, the DevExpress Blazor Pivot Table renders data on demand as users scroll through rows/columns.