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.