Overview

The Blazor Pivot Table component is currently available as a community technology preview (CTP).

 
2023 Total 2024 Total Grand Total
Q3 Q4 Q1 Q2 Q3 Q4 Q1
Model Price Discount Model Price Discount Model Price Discount Model Price Discount Model Price Discount Model Price Discount Model Price Discount Model Price Discount Model Price Discount Model Price Discount
TT RS $116,190 13% $116,190 13% $58,095 15% $116,190 5% $58,095 5% $116,190 8% $348,570 8% $58,095 0% $522,855 8%
S8 $110,895 5% $221,790 8% $332,685 7% $998,055 6% $110,895 0% $332,685 8% $221,790 8% $1,663,425 6% $110,895 5% $2,107,005 6%
Q5 $110,385 7% $110,385 7% $36,795 5% $220,770 9% $220,770 8% $36,795 15% $515,130 9% $625,515 8%
Allroad $40,495 0% $80,990 13% $121,485 8% $161,980 5% $80,990 3% $202,475 9% $40,495 5% $485,940 6% $40,495 15% $647,920 7%
A6 $43,095 5% $43,095 5% $86,190 5% $129,285 5% $129,285 5% $129,285 7% $172,380 9% $560,235 7% $43,095 10% $689,520 7%
Audi Total $194,485 3% $572,450 9% $766,935 8% $1,384,210 6% $658,130 6% $943,310 8% $587,650 9% $3,573,300 7% $252,580 8% $4,592,815 7%
Z4 Sdrive35i $168,225 2% $224,300 4% $392,525 3% $56,075 10% $168,225 5% $56,075 5% $280,375 6% $672,900 4%
X6 $71,325 5% $285,300 11% $356,625 10% $285,300 6% $142,650 10% $142,650 13% $71,325 10% $641,925 9% $998,550 9%
X3 $79,550 8% $119,325 7% $198,875 7% $79,550 3% $39,775 0% $79,550 0% $79,550 13% $278,425 4% $477,300 5%
M5 $182,250 10% $91,125 15% $273,375 12% $364,500 3% $182,250 8% $91,125 0% $182,250 0% $820,125 3% $91,125 10% $1,184,625 5%
760li $141,625 0% $141,625 0% $141,625 15% $283,250 10% $424,875 12% $566,500 4% $1,133,000 6%
BMW Total $642,975 5% $720,050 8% $1,363,025 7% $927,050 5% $816,150 7% $369,400 5% $333,125 7% $2,445,725 6% $657,625 5% $4,466,375 6%
Tahoe $82,800 3% $82,800 3% $82,800 5% $248,400 8% $248,400 4% $165,600 10% $745,200 7% $41,400 5% $869,400 6%
Silverado 1500 Regular CAB 4WD $67,300 10% $67,300 3% $134,600 6% $33,650 0% $33,650 15% $33,650 5% $100,950 7% $67,300 5% $302,850 6%
Malibu $22,805 15% $22,805 0% $45,610 8% $68,415 5% $45,610 10% $45,610 10% $159,635 8% $205,245 8%
Corvette Coupe $490,380 6% $490,380 6% $245,190 5% $367,785 13% $735,570 6% $490,380 10% $1,838,925 8% $122,595 5% $2,451,900 8%
Camaro $55,250 10% $55,250 10% $165,750 0% $221,000 13% $386,750 6% $55,250 10% $828,750 7% $55,250 15% $939,250 8%
Chevrolet Total $145,355 11% $663,285 4% $808,640 6% $595,805 3% $882,795 10% $1,404,370 6% $790,490 10% $3,673,460 7% $286,545 7% $4,768,645 7%
Town & Country $126,420 10% $42,140 15% $168,560 11% $337,120 11% $42,140 15% $379,260 12%
200 Convertible $68,030 5% $34,015 0% $102,045 3% $34,015 10% $68,030 5% $68,030 5% $170,075 6% $272,120 5%
Chrysler Total $68,030 5% $34,015 0% $102,045 3% $34,015 10% $194,450 8% $42,140 15% $236,590 9% $507,195 9% $42,140 15% $651,380 9%
SRT Viper $244,780 10% $244,780 15% $489,560 13% $489,560 6% $367,170 12% $611,950 7% $611,950 8% $2,080,630 8% $2,570,190 9%
Grand Caravan $27,690 10% $27,690 10% $55,380 10% $55,380 8% $110,760 5% $166,140 3% $332,280 5% $387,660 5%
Durango $30,790 0% $30,790 0% $92,370 3% $30,790 15% $61,580 8% $61,580 13% $246,320 8% $30,790 15% $307,900 8%
Charger $27,290 10% $27,290 0% $54,580 5% $54,580 5% $27,290 10% $81,870 7% $27,290 5% $191,030 6% $27,290 10% $272,900 7%
Challenger $45,190 0% $135,570 0% $180,760 0% $180,760 9% $90,380 13% $225,950 5% $90,380 13% $587,470 8% $768,230 6%
Dodge Total $375,740 7% $435,330 6% $811,070 6% $872,650 6% $626,390 10% $1,147,490 5% $791,200 10% $3,437,730 7% $58,080 13% $4,306,880 7%
Taurus $200,475 9% $200,475 9% $120,285 3% $160,380 6% $240,570 10% $120,285 8% $641,520 8% $40,095 0% $882,090 8%
F-350 SD Supercab 4X4 $96,100 0% $240,250 7% $336,350 5% $96,100 3% $144,150 10% $96,100 5% $192,200 5% $528,550 6% $48,050 0% $912,950 5%
F-150 Regular CAB 4X4 $127,600 8% $127,600 8% $63,800 3% $159,500 10% $63,800 10% $63,800 8% $350,900 8% $95,700 5% $574,200 8%
Expedition $41,600 5% $83,200 8% $124,800 7% $83,200 13% $124,800 13% $41,600 0% $41,600 0% $291,200 9% $41,600 10% $457,600 9%
Edge $63,990 3% $127,980 6% $191,970 5% $63,990 13% $31,995 5% $31,995 5% $63,990 5% $191,970 8% $31,995 5% $415,935 6%
Ford Total $201,690 2% $779,505 8% $981,195 6% $427,375 6% $620,825 9% $474,065 8% $481,875 6% $2,004,140 8% $257,440 4% $3,242,775 7%
Odyssey $65,310 13% $97,965 12% $163,275 12% $32,655 15% $97,965 2% $97,965 10% $228,585 7% $97,965 5% $489,825 8%
Crosstour $28,060 15% $56,120 8% $84,180 10% $56,120 10% $56,120 15% $56,120 10% $84,180 10% $252,540 11% $140,300 8% $477,020 10%
Accord $30,860 5% $61,720 13% $92,580 10% $92,580 10% $92,580 12% $185,160 8% $30,860 15% $401,180 10% $61,720 8% $555,480 10%
Honda Total $124,230 11% $215,805 11% $340,035 11% $181,355 11% $246,665 9% $339,245 9% $115,040 11% $882,305 10% $299,985 7% $1,522,325 9%
Sportage $87,750 3% $29,250 10% $117,000 5% $117,000 4% $58,500 3% $29,250 10% $29,250 10% $234,000 5% $29,250 0% $380,250 5%
Soul $20,700 10% $82,800 4% $103,500 5% $82,800 8% $82,800 9% $62,100 13% $227,700 10% $62,100 2% $393,300 7%
RIO $17,300 15% $17,300 15% $17,300 15% $86,500 11% $69,200 4% $173,000 9% $69,200 5% $259,500 8%
KIA Total $108,450 5% $129,350 7% $237,800 6% $134,300 6% $227,800 8% $181,250 7% $91,350 13% $634,700 8% $160,550 3% $1,033,050 7%
Range Rover Supercharged $299,985 7% $499,975 4% $799,960 5% $299,985 12% $199,990 3% $199,990 3% $699,965 6% $299,985 8% $1,799,910 6%
Range Rover Evoque $84,080 5% $84,080 5% $168,160 5% $126,120 12% $126,120 10% $126,120 3% $84,080 8% $462,440 8% $630,600 7%
LR4 $199,980 5% $99,990 0% $299,970 3% $49,995 0% $99,990 15% $199,980 10% $149,985 2% $499,950 8% $799,920 6%
Land Rover Total $584,045 6% $684,045 3% $1,268,090 4% $476,100 10% $426,100 9% $326,100 7% $434,055 4% $1,662,355 8% $299,985 8% $3,230,430 6%
RX 350 $41,955 0% $209,775 3% $251,730 3% $167,820 11% $167,820 10% $41,955 10% $377,595 11% $41,955 0% $671,280 7%
LX 570 $164,850 13% $164,850 10% $329,700 11% $329,700 9% $329,700 10% $412,125 9% $1,071,525 9% $164,850 5% $1,566,075 9%
IS 350 $87,350 13% $43,675 15% $131,025 13% $87,350 8% $174,700 5% $218,375 7% $87,350 10% $567,775 7% $698,800 8%
Lexus Total $294,155 10% $418,300 6% $712,455 8% $255,170 10% $672,220 8% $548,075 8% $541,430 9% $2,016,895 9% $206,805 3% $2,936,155 8%
Mx-5 Miata $98,060 6% $98,060 6% $122,575 8% $49,030 0% $73,545 3% $245,150 5% $49,030 0% $392,240 5%
Mazda6 $21,520 15% $43,040 0% $64,560 5% $43,040 0% $129,120 9% $172,160 9% $21,520 15% $365,840 9% $21,520 10% $451,920 8%
Cx-5 $87,160 11% $87,160 11% $196,110 3% $108,950 5% $87,160 8% $21,790 10% $414,010 5% $21,790 10% $522,960 6%
Mazda Total $21,520 15% $228,260 7% $249,780 8% $361,725 4% $287,100 6% $332,865 8% $43,310 13% $1,025,000 6% $92,340 5% $1,367,120 6%
Slk350 $56,305 5% $56,305 5% $112,610 10% $112,610 5% $56,305 0% $112,610 10% $394,135 7% $56,305 15% $506,745 8%
S600 $161,205 0% $161,205 0% $322,410 8% $806,025 9% $322,410 5% $161,205 5% $1,612,050 8% $161,205 10% $1,934,460 7%
Ml350 $48,175 15% $144,525 12% $192,700 13% $144,525 8% $48,175 0% $48,175 5% $48,175 10% $289,050 7% $481,750 9%
G550 $227,810 3% $341,715 5% $569,525 4% $113,905 5% $113,905 15% $455,620 10% $455,620 11% $1,139,050 11% $113,905 0% $1,822,480 8%
Cls550 $291,620 9% $291,620 9% $145,810 8% $145,810 8% $218,715 2% $218,715 12% $729,050 7% $72,905 10% $1,093,575 8%
Mercedes-Benz Total $437,190 5% $834,165 8% $1,271,355 7% $839,260 8% $1,226,525 8% $1,101,225 5% $996,325 10% $4,163,335 8% $404,320 9% $5,839,010 8%
Outlander $88,260 8% $29,420 15% $117,680 10% $117,680 3% $29,420 5% $147,100 3% $264,780 6%
Lancer $20,790 0% $62,370 7% $20,790 5% $20,790 10% $124,740 6% $124,740 6%
Mitsubishi Total $88,260 8% $29,420 15% $117,680 10% $138,470 2% $62,370 7% $50,210 5% $20,790 10% $271,840 5% $389,520 6%
Murano $87,855 7% $29,285 5% $117,140 6% $175,710 4% $58,570 13% $234,280 6% $351,420 6%
Maxima $68,060 3% $68,060 3% $34,030 5% $34,030 10% $68,060 13% $136,120 10% $68,060 13% $272,240 9%
Altima $31,350 15% $31,350 15% $31,350 10% $62,700 8% $62,700 15% $156,750 11% $188,100 12%
Nissan Total $87,855 7% $128,695 6% $216,550 6% $209,740 4% $89,920 12% $96,730 8% $130,760 14% $527,150 9% $68,060 13% $811,760 8%
3500 Regular CAB 4X4 $103,110 10% $103,110 10% $34,370 10% $103,110 10% $68,740 15% $137,480 13% $343,700 12% $103,110 7% $549,920 11%
2500 Mega CAB 4X4 $42,460 15% $42,460 0% $84,920 8% $84,920 5% $84,920 13% $127,380 7% $127,380 7% $424,600 8% $84,920 5% $594,440 7%
1500 Regular CAB 4X4 $32,825 10% $32,825 10% $98,475 7% $98,475 8% $98,475 13% $131,300 8% $426,725 9% $459,550 9%
RAM Total $42,460 15% $178,395 8% $220,855 9% $217,765 7% $286,505 10% $294,595 11% $396,160 9% $1,195,025 9% $188,030 6% $1,603,910 9%
Outback $175,740 3% $175,740 3% $29,290 15% $58,580 13% $87,870 5% $87,870 8% $263,610 9% $58,580 13% $497,930 7%
Impreza $57,495 5% $57,495 5% $57,495 7% $38,330 5% $76,660 6% $76,660 6% $249,145 6% $306,640 6%
Forester $22,090 15% $22,090 0% $44,180 8% $22,090 0% $44,180 15% $132,540 11% $110,450 1% $309,260 7% $353,440 7%
Subaru Total $22,090 15% $255,325 3% $277,415 4% $108,875 7% $141,090 11% $297,070 8% $274,980 5% $822,015 7% $58,580 13% $1,158,010 7%
Grand Vitara $80,397 7% $53,598 0% $133,995 4% $26,799 0% $53,598 10% $80,397 5% $80,397 7% $241,191 6% $375,186 5%
Venza $57,390 5% $57,390 13% $114,780 9% $57,390 13% $114,780 8% $57,390 10% $229,560 9% $28,695 0% $373,035 8%
Tundra 4x4 Reg. Cab $31,645 0% $31,645 0% $94,935 8% $126,580 4% $63,290 13% $94,935 7% $379,740 7% $31,645 15% $443,030 7%
Sienna $61,960 10% $123,920 8% $185,880 8% $185,880 3% $61,960 0% $61,960 8% $123,920 9% $433,720 5% $619,600 6%
Sequoia $86,900 5% $217,250 4% $304,150 4% $130,350 3% $43,450 0% $86,900 10% $260,700 5% $564,850 5%
Camry $31,260 10% $31,260 10% $93,780 10% $62,520 5% $93,780 10% $125,040 9% $375,120 9% $31,260 5% $437,640 9%
Avalon $63,570 5% $31,785 0% $95,355 3% $254,280 9% $31,785 15% $95,355 7% $381,420 9% $63,570 10% $540,345 8%
Toyota Total $301,080 7% $461,990 6% $763,070 6% $562,335 6% $548,790 6% $452,495 10% $496,640 8% $2,060,260 7% $155,170 8% $2,978,500 7%
Touareg $144,960 8% $144,960 8% $48,320 15% $48,320 5% $96,640 10% $96,640 8% $289,920 9% $434,880 9%
Tiguan $23,820 0% $71,460 10% $95,280 8% $71,460 10% $71,460 10% $95,280 9% $95,280 5% $333,480 8% $428,760 8%
Jetta $59,430 12% $59,430 7% $118,860 9% $19,810 0% $19,810 0% $19,810 5% $79,240 10% $138,670 6% $39,620 5% $297,150 7%
Golf $18,890 5% $37,780 8% $56,670 7% $75,560 4% $56,670 7% $37,780 10% $170,010 6% $56,670 7% $283,350 6%
Volkswagen Total $102,140 8% $313,630 8% $415,770 8% $215,150 7% $196,260 7% $249,510 9% $271,160 8% $932,080 8% $96,290 6% $1,444,140 8%
Grand Total $3,922,147 7% $7,135,613 7% $11,057,760 7% $7,968,149 6% $8,263,683 8% $8,730,542 7% $7,113,327 8% $32,075,701 8% $3,584,525 7% $46,717,986 7%

The Blazor Pivot Table UI component summarizes data from the underlying data source and presents the results in cross-tabulated format. It ships with the following features/capabilities:

  • High-performance data engine
  • Data sorting support
  • DateTime, numeric, alphabetic, and custom group intervals
  • Configurable totals and grand totals
  • Built-in scroll bar and sticky Header/Row Value areas
  • Virtual scrolling support
  • Value formatting and integrated templates

In this demo, the Pivot Table allows you to browse prices and discounts for different car models per years and quarters. It also calculates and displays sub-totals and grand totals for these data.