Large Data Source

Community Technology Preview (CTP)

 
Quantity
Unit Price
Year
Quarter
Product Name
Sales Person Name
2024
2024 Total
2025
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
Amazing Butter
Alex Brown346$519.05116$101.66219$350.35109$359.12790$1,330.19311$273.01155$214.6674$247.7654$121.20594$856.631384$2,186.82
Alex Burton73$292.55176$286.6466$210.13217$351.66532$1,140.9845$46.8775$263.61263$452.4792$59.55475$822.501007$1,963.49
Alex Fox344$475.6259$292.5048$68.89223$512.98674$1,349.99247$538.38300$497.25149$292.48322$405.201018$1,733.301692$3,083.29
Alex Parker376$495.50236$396.40142$228.27754$1,120.17421$459.4498$257.40227$665.03167$215.16913$1,597.031667$2,717.20
Alex Simpson96$126.20123$130.51105$155.83304$499.35628$911.8860$228.55467$628.04134$202.18421$757.341082$1,816.111710$2,727.99
Alex White245$463.7258$67.0746$202.35156$204.75505$937.8958$169.49170$387.15105$287.44333$844.08838$1,781.98
Alice Cooper85$273.89109$415.26249$310.26186$264.07629$1,263.49177$264.3660$205.17411$706.3697$267.74745$1,443.631374$2,707.11
Alice Fox260$419.72280$280.61174$302.5896$278.63810$1,281.5363$167.93107$233.37107$209.0295$69.87372$680.191182$1,961.72
Alice Simpson113$229.577$82.81228$423.43133$209.84481$945.65162$516.78114$204.10182$323.86117$264.66575$1,309.391056$2,255.04
Curtis Black156$200.48169$153.59104$180.14187$365.51616$899.71179$192.17110$196.75122$174.39314$406.96725$970.271341$1,869.98
Curtis Brown317$377.00281$541.67311$337.57103$130.241012$1,386.47172$281.3911$123.5452$208.88235$613.821247$2,000.29
Curtis Burton179$185.41192$272.40270$249.36180$479.97821$1,187.1475$206.39215$307.9568$77.8867$134.48425$726.711246$1,913.85
Curtis Parker64$128.13201$295.81293$370.09282$471.19840$1,265.21157$316.4650$99.72200$274.22400$569.24807$1,259.641647$2,524.86
Curtis White203$488.5480$506.35645$898.86928$1,893.75115$167.49185$129.48210$367.23196$303.35706$967.551634$2,861.30
Jack Cooper16$90.92332$425.91161$190.65509$707.48294$269.34177$374.47101$401.38139$313.17711$1,358.361220$2,065.85
Jack Douglas102$195.0869$82.45254$432.50256$480.61681$1,190.62139$237.8532$115.80164$321.1420$63.09355$737.881036$1,928.51
Jack Parker25$54.18112$211.42113$257.94250$523.54354$625.80143$234.6578$249.80366$715.65941$1,825.901191$2,349.44
John Black91$118.20112$241.72116$343.59191$362.44510$1,065.95149$134.94276$443.01221$298.39646$876.341156$1,942.29
John Cooper68$203.15136$422.54203$248.13407$873.82154$306.75196$411.08167$252.5815$80.00532$1,050.41939$1,924.23
John Douglas309$858.5790$345.1937$220.00436$1,423.76237$583.56206$301.50118$292.94288$365.62849$1,543.621285$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.