Large Data Source

 
Quantity
Unit Price
Year
Quarter
Month
Product Name
Sales Person Name
2023
Q1
Q1 Total
Q2
Q2 Total
Q3
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
Amazing Butter
Alex Cooper
95$772.4195$772.4111$280.2311$280.2318$177.187$264.75
Alex Douglas
154$708.8192$208.95246$917.7556$483.8213$222.0069$705.8290$451.04
Alex Fox
13$472.1513$472.1553$436.6653$436.66117$818.75
Alex Parker
59$295.0159$295.0177$421.6051$300.7337$333.04165$1,055.36
Alex Smith
37$672.7937$672.7927$487.3027$487.30
Alex Walker
79$440.1879$440.1876$250.9876$250.9837$466.61
Alice Black
26$513.2361$471.6487$984.8773$437.0673$437.0668$190.17
Alice Brown
21$247.4727$454.8048$702.2787$415.37
Alice Burton
92$303.6927$461.76119$765.4492$611.3599$551.99191$1,163.3418$452.59
Alice Cooper
15$485.6189$435.99104$921.60150$743.8544$245.00194$988.85
Alice Fox
7$330.757$330.75
Alice Smith
61$300.0261$300.02180$1,062.24122$476.60302$1,538.84
Alice Walker
61$464.2545$339.5461$881.09167$1,684.88110$699.47110$699.472$472.67
Curtis Burton
91$212.8391$212.83
Curtis Cooper
5$196.0455$188.0860$384.1211$338.93
Curtis Douglas
99$318.4899$318.4828$206.6228$206.62144$656.34
Jack Burton
97$825.6897$825.6831$334.3534$357.3865$691.74
Jack Simpson
30$282.8530$282.85
Jack Walker
146$964.08146$964.0837$246.2737$246.27
John Fox
180$578.47180$578.4757$334.06119$726.37176$1,060.43

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.