Large Data Source

 
Quantity
Unit Price
Year
Quarter
Month
Product Name
Sales Person Name
2023
Q1
Q1 Total
Q2
Q2 Total
Q3
JanuaryFebruaryMarchAprilMayJuneJulyAugust
QuantityUnit PriceQuantityUnit PriceQuantityUnit PriceQuantityUnit PriceQuantityUnit PriceQuantityUnit PriceQuantityUnit PriceQuantityUnit PriceQuantityUnit PriceQuantityUnit Price
Amazing Armchair
Alex Burton
14$56.2814$56.2859$61.50
Alex Hunter
96$134.4548$89.79144$224.24
Alex Simpson
163$107.3893$57.82256$165.2132$84.78
Alex White
114$102.6173$69.9687$117.96274$290.534$62.6290$49.6294$112.2457$86.22
Alice Black
67$145.5072$63.33139$208.8485$37.0785$37.07
Alice Burton
84$123.26124$113.67208$236.9251$138.1251$138.1222$59.38
Alice Parker
67$67.5744$70.85111$138.4298$76.80127$88.70225$165.4952$36.01
Alice Walker
Alice White
113$134.6449$87.96162$222.5945$61.6445$61.6410$60.6518$53.31
Curtis Black
80$93.17
Curtis Burton
79$93.0079$93.00113$199.7591$51.92204$251.66
Curtis Cooper
78$119.9020$83.3998$203.2912$34.26
Curtis Parker
43$61.0443$61.04
Curtis Simpson
87$58.846$54.1393$112.9786$74.2986$74.2957$96.8181$74.40
Curtis White
20$88.8764$86.3929$44.79113$220.0583$92.4530$37.46113$129.91105$157.33
Jack Hunter
31$79.24
John Burton
79$58.1779$58.1764$41.5064$41.50138$180.00
John Cooper
46$54.7146$54.7126$41.3749$33.46131$137.59206$212.42
John Hunter
45$61.8345$61.83190$222.9615$60.34205$283.3080$79.9729$48.67
John Smith
8$71.988$71.9851$56.2051$56.20

Our Blazor Pivot Table can aggregate large data sources efficiently and allows users to navigate and sort data with ease.

This demo allows you to test Pivot Table performance when bound to a data source with thousands of rows.

To optimize component performance against large datasets, this demo uses column and row virtualization. When you activate the VirtualScrollingEnabled option, the DevExpress Blazor Pivot Table renders data on demand as users scroll through rows/columns.