Community Technology Preview (CTP)
|
Model Price
Discount
|
Sales Date
Quarter
|
||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Trademark
|
Name
|
2024 Total | 2025 Total | Grand Total | |||||||||||||||||
| Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | |||||||||||||||
| 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 | $58,095 | 10% | $58,095 | 15% | $116,190 | 10% | $232,380 | 11% | $116,190 | 5% | $116,190 | 8% | $58,095 | 0% | $290,475 | 5% | $522,855 | 8% | |||
| S8 | $332,685 | 7% | $776,265 | 7% | $221,790 | 0% | $1,330,740 | 6% | $221,790 | 5% | $332,685 | 5% | $221,790 | 10% | $776,265 | 6% | $2,107,005 | 6% | |||
| Q5 | $36,795 | 5% | $110,385 | 7% | $110,385 | 8% | $257,565 | 7% | $331,155 | 8% | $36,795 | 15% | $367,950 | 9% | $625,515 | 8% | |||||
| Allroad | $121,485 | 8% | $121,485 | 5% | $80,990 | 5% | $323,960 | 6% | $161,980 | 4% | $121,485 | 12% | $40,495 | 15% | $323,960 | 8% | $647,920 | 7% | |||
| A6 | $43,095 | 5% | $43,095 | 5% | $129,285 | 5% | $215,475 | 5% | $258,570 | 6% | $129,285 | 8% | $86,190 | 10% | $474,045 | 7% | $689,520 | 7% | |||
| Audi Total | $592,155 | 7% | $1,109,325 | 7% | $658,640 | 6% | $2,360,120 | 7% | $1,089,685 | 6% | $736,440 | 9% | $406,570 | 9% | $2,232,695 | 7% | $4,592,815 | 7% | |||
| Z4 Sdrive35i | $56,075 | 0% | $280,375 | 2% | $112,150 | 10% | $56,075 | 5% | $504,675 | 4% | $112,150 | 5% | $56,075 | 5% | $168,225 | 5% | $672,900 | 4% | |||
| X6 | $285,300 | 10% | $213,975 | 7% | $142,650 | 8% | $641,925 | 8% | $142,650 | 10% | $142,650 | 13% | $71,325 | 10% | $356,625 | 11% | $998,550 | 9% | |||
| X3 | $39,775 | 0% | $119,325 | 8% | $79,550 | 8% | $79,550 | 0% | $318,200 | 5% | $79,550 | 0% | $79,550 | 13% | $159,100 | 6% | $477,300 | 5% | |||
| M5 | $182,250 | 10% | $91,125 | 15% | $91,125 | 5% | $455,625 | 4% | $820,125 | 7% | $91,125 | 0% | $91,125 | 0% | $182,250 | 5% | $364,500 | 3% | $1,184,625 | 5% | |
| 760li | $141,625 | 0% | $424,875 | 12% | $566,500 | 9% | $566,500 | 4% | $566,500 | 4% | $1,133,000 | 6% | |||||||||
| BMW Total | $278,100 | 5% | $917,750 | 6% | $496,800 | 8% | $1,158,775 | 6% | $2,851,425 | 6% | $425,475 | 4% | $369,400 | 9% | $820,075 | 5% | $1,614,950 | 6% | $4,466,375 | 6% | |
| Tahoe | $41,400 | 5% | $41,400 | 0% | $207,000 | 6% | $289,800 | 5% | $289,800 | 6% | $207,000 | 10% | $82,800 | 3% | $579,600 | 7% | $869,400 | 6% | |||
| Silverado 1500 Regular CAB 4WD | $134,600 | 6% | $33,650 | 0% | $168,250 | 5% | $33,650 | 15% | $100,950 | 5% | $134,600 | 8% | $302,850 | 6% | |||||||
| Malibu | $22,805 | 15% | $22,805 | 0% | $45,610 | 5% | $68,415 | 8% | $159,635 | 7% | $45,610 | 10% | $45,610 | 10% | $205,245 | 8% | |||||
| Corvette Coupe | $245,190 | 13% | $490,380 | 3% | $122,595 | 10% | $858,165 | 6% | $858,165 | 7% | $245,190 | 13% | $490,380 | 9% | $1,593,735 | 8% | $2,451,900 | 8% | |||
| Camaro | $55,250 | 10% | $55,250 | 0% | $276,250 | 7% | $386,750 | 6% | $331,500 | 5% | $165,750 | 13% | $55,250 | 15% | $552,500 | 9% | $939,250 | 8% | |||
| Chevrolet Total | $22,805 | 15% | $499,245 | 7% | $632,640 | 3% | $707,910 | 7% | $1,862,600 | 6% | $1,479,465 | 6% | $651,590 | 12% | $774,990 | 8% | $2,906,045 | 8% | $4,768,645 | 7% | |
| Town & Country | $42,140 | 10% | $42,140 | 10% | $126,420 | 12% | $42,140 | 5% | $168,560 | 14% | $337,120 | 12% | $379,260 | 12% | |||||||
| 200 Convertible | $68,030 | 5% | $68,030 | 5% | $136,060 | 5% | $68,030 | 5% | $34,015 | 10% | $34,015 | 0% | $136,060 | 5% | $272,120 | 5% | |||||
| Chrysler Total | $68,030 | 5% | $68,030 | 5% | $42,140 | 10% | $178,200 | 6% | $194,450 | 9% | $76,155 | 8% | $202,575 | 11% | $473,180 | 10% | $651,380 | 9% | |||
| SRT Viper | $489,560 | 13% | $244,780 | 5% | $489,560 | 11% | $1,223,900 | 11% | $244,780 | 3% | $734,340 | 9% | $367,170 | 7% | $1,346,290 | 7% | $2,570,190 | 9% | |||
| Grand Caravan | $27,690 | 10% | $27,690 | 10% | $83,070 | 8% | $138,450 | 9% | $193,830 | 4% | $55,380 | 0% | $249,210 | 3% | $387,660 | 5% | |||||
| Durango | $30,790 | 0% | $61,580 | 3% | $30,790 | 5% | $123,160 | 3% | $61,580 | 10% | $92,370 | 12% | $30,790 | 15% | $184,740 | 12% | $307,900 | 8% | |||
| Charger | $54,580 | 5% | $27,290 | 10% | $27,290 | 0% | $109,160 | 5% | $81,870 | 8% | $54,580 | 5% | $27,290 | 10% | $163,740 | 8% | $272,900 | 7% | |||
| Challenger | $135,570 | 0% | $180,760 | 5% | $90,380 | 13% | $406,710 | 5% | $135,570 | 7% | $180,760 | 9% | $45,190 | 10% | $361,520 | 8% | $768,230 | 6% | |||
| Dodge Total | $27,690 | 10% | $738,190 | 6% | $514,410 | 5% | $721,090 | 9% | $2,001,380 | 7% | $717,630 | 6% | $1,117,430 | 8% | $470,440 | 9% | $2,305,500 | 7% | $4,306,880 | 7% | |
| Taurus | $160,380 | 11% | $40,095 | 0% | $160,380 | 6% | $360,855 | 8% | $280,665 | 6% | $200,475 | 11% | $40,095 | 0% | $521,235 | 7% | $882,090 | 8% | |||
| F-350 SD Supercab 4X4 | $192,200 | 4% | $144,150 | 7% | $240,250 | 7% | $576,600 | 6% | $96,100 | 5% | $48,050 | 15% | $192,200 | 1% | $336,350 | 4% | $912,950 | 5% | |||
| F-150 Regular CAB 4X4 | $127,600 | 8% | $31,900 | 5% | $127,600 | 6% | $287,100 | 7% | $95,700 | 10% | $63,800 | 15% | $127,600 | 4% | $287,100 | 8% | $574,200 | 8% | |||
| Expedition | $83,200 | 3% | $83,200 | 13% | $124,800 | 13% | $291,200 | 10% | $41,600 | 15% | $83,200 | 0% | $41,600 | 10% | $166,400 | 6% | $457,600 | 9% | |||
| Edge | $159,975 | 5% | $63,990 | 8% | $63,990 | 10% | $287,955 | 7% | $31,995 | 5% | $31,995 | 5% | $63,990 | 5% | $127,980 | 5% | $415,935 | 6% | |||
| Ford Total | $723,355 | 6% | $363,335 | 7% | $717,020 | 8% | $1,803,710 | 7% | $546,060 | 7% | $427,520 | 10% | $465,485 | 3% | $1,439,065 | 7% | $3,242,775 | 7% | |||
| Odyssey | $163,275 | 12% | $32,655 | 15% | $65,310 | 3% | $261,240 | 10% | $97,965 | 5% | $32,655 | 15% | $97,965 | 5% | $228,585 | 6% | $489,825 | 8% | |||
| Crosstour | $28,060 | 15% | $56,120 | 8% | $56,120 | 10% | $140,300 | 10% | $84,180 | 12% | $56,120 | 13% | $196,420 | 9% | $336,720 | 10% | $477,020 | 10% | |||
| Accord | $61,720 | 10% | $61,720 | 5% | $123,440 | 14% | $246,880 | 11% | $123,440 | 10% | $123,440 | 9% | $61,720 | 8% | $308,600 | 9% | $555,480 | 10% | |||
| Honda Total | $28,060 | 15% | $281,115 | 11% | $150,495 | 9% | $188,750 | 10% | $648,420 | 10% | $305,585 | 9% | $212,215 | 11% | $356,105 | 8% | $873,905 | 9% | $1,522,325 | 9% | |
| Sportage | $29,250 | 0% | $87,750 | 7% | $117,000 | 4% | $29,250 | 5% | $263,250 | 4% | $29,250 | 0% | $58,500 | 10% | $29,250 | 0% | $117,000 | 5% | $380,250 | 5% | |
| Soul | $20,700 | 10% | $62,100 | 5% | $20,700 | 0% | $41,400 | 5% | $144,900 | 5% | $103,500 | 10% | $62,100 | 10% | $82,800 | 5% | $248,400 | 8% | $393,300 | 7% | |
| RIO | $17,300 | 15% | $17,300 | 15% | $51,900 | 13% | $86,500 | 14% | $86,500 | 5% | $17,300 | 5% | $69,200 | 5% | $173,000 | 5% | $259,500 | 8% | |||
| KIA Total | $49,950 | 5% | $167,150 | 7% | $155,000 | 5% | $122,550 | 9% | $494,650 | 7% | $219,250 | 7% | $137,900 | 9% | $181,250 | 4% | $538,400 | 7% | $1,033,050 | 7% | |
| Range Rover Supercharged | $499,975 | 4% | $599,970 | 9% | $1,099,945 | 7% | $199,990 | 3% | $499,975 | 6% | $699,965 | 5% | $1,799,910 | 6% | |||||||
| Range Rover Evoque | $42,040 | 5% | $42,040 | 5% | $126,120 | 7% | $210,200 | 11% | $420,400 | 9% | $126,120 | 3% | $42,040 | 15% | $42,040 | 0% | $210,200 | 5% | $630,600 | 7% | |
| LR4 | $299,970 | 3% | $49,995 | 0% | $49,995 | 15% | $399,960 | 4% | $99,990 | 13% | $199,980 | 9% | $99,990 | 0% | $399,960 | 8% | $799,920 | 6% | |||
| Land Rover Total | $42,040 | 5% | $841,985 | 4% | $776,085 | 8% | $260,195 | 12% | $1,920,305 | 7% | $426,100 | 6% | $242,020 | 10% | $642,005 | 4% | $1,310,125 | 6% | $3,230,430 | 6% | |
| RX 350 | $209,775 | 3% | $167,820 | 9% | $167,820 | 10% | $545,415 | 7% | $41,955 | 10% | $83,910 | 5% | $125,865 | 7% | $671,280 | 7% | |||||
| LX 570 | $82,425 | 15% | $164,850 | 10% | $82,425 | 10% | $247,275 | 8% | $576,975 | 10% | $412,125 | 10% | $329,700 | 9% | $247,275 | 7% | $989,100 | 9% | $1,566,075 | 9% | |
| IS 350 | $43,675 | 15% | $87,350 | 13% | $87,350 | 8% | $131,025 | 5% | $349,400 | 9% | $218,375 | 7% | $87,350 | 5% | $43,675 | 15% | $349,400 | 8% | $698,800 | 8% | |
| Lexus Total | $126,100 | 15% | $461,975 | 7% | $337,595 | 9% | $546,120 | 8% | $1,471,790 | 8% | $672,455 | 9% | $417,050 | 8% | $374,860 | 8% | $1,464,365 | 8% | $2,936,155 | 8% | |
| Mx-5 Miata | $24,515 | 0% | $147,090 | 8% | $98,060 | 4% | $269,665 | 6% | $24,515 | 0% | $49,030 | 5% | $49,030 | 0% | $122,575 | 2% | $392,240 | 5% | |||
| Mazda6 | $43,040 | 8% | $64,560 | 0% | $43,040 | 10% | $150,640 | 5% | $193,680 | 9% | $86,080 | 10% | $21,520 | 10% | $301,280 | 10% | $451,920 | 8% | |||
| Cx-5 | $65,370 | 15% | $152,530 | 4% | $108,950 | 2% | $326,850 | 5% | $130,740 | 8% | $21,790 | 0% | $43,580 | 10% | $196,110 | 8% | $522,960 | 6% | |||
| Mazda Total | $132,925 | 10% | $364,180 | 5% | $250,050 | 4% | $747,155 | 5% | $348,935 | 8% | $156,900 | 7% | $114,130 | 6% | $619,965 | 8% | $1,367,120 | 6% | |||
| Slk350 | $56,305 | 5% | $56,305 | 10% | $168,915 | 7% | $281,525 | 7% | $112,610 | 8% | $112,610 | 10% | $225,220 | 9% | $506,745 | 8% | |||||
| S600 | $161,205 | 0% | $161,205 | 10% | $483,615 | 5% | $806,025 | 5% | $806,025 | 9% | $322,410 | 8% | $1,128,435 | 9% | $1,934,460 | 7% | |||||
| Ml350 | $192,700 | 13% | $96,350 | 13% | $96,350 | 0% | $385,400 | 9% | $48,175 | 5% | $48,175 | 10% | $96,350 | 8% | $481,750 | 9% | |||||
| G550 | $113,905 | 5% | $227,810 | 3% | $227,810 | 5% | $227,810 | 10% | $797,335 | 6% | $227,810 | 13% | $455,620 | 8% | $341,715 | 10% | $1,025,145 | 9% | $1,822,480 | 8% | |
| Cls550 | $145,810 | 8% | $218,715 | 8% | $145,810 | 5% | $510,335 | 7% | $218,715 | 5% | $218,715 | 8% | $145,810 | 13% | $583,240 | 8% | $1,093,575 | 8% | |||
| Mercedes-Benz Total | $113,905 | 5% | $783,830 | 8% | $760,385 | 9% | $1,122,500 | 5% | $2,780,620 | 7% | $1,300,725 | 8% | $835,120 | 8% | $922,545 | 10% | $3,058,390 | 9% | $5,839,010 | 8% | |
| Outlander | $29,420 | 5% | $58,840 | 10% | $58,840 | 8% | $88,260 | 3% | $235,360 | 6% | $29,420 | 5% | $29,420 | 5% | $264,780 | 6% | |||||
| Lancer | $20,790 | 0% | $20,790 | 10% | $41,580 | 5% | $62,370 | 5% | $20,790 | 10% | $83,160 | 6% | $124,740 | 6% | |||||||
| Mitsubishi Total | $29,420 | 5% | $58,840 | 10% | $79,630 | 5% | $109,050 | 5% | $276,940 | 6% | $91,790 | 5% | $20,790 | 10% | $112,580 | 6% | $389,520 | 6% | |||
| Murano | $117,140 | 6% | $87,855 | 7% | $146,425 | 6% | $351,420 | 6% | $351,420 | 6% | |||||||||||
| Maxima | $34,030 | 5% | $68,060 | 3% | $102,090 | 3% | $68,060 | 10% | $102,090 | 13% | $170,150 | 12% | $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 | $151,170 | 6% | $187,265 | 7% | $146,425 | 6% | $484,860 | 6% | $31,350 | 10% | $130,760 | 9% | $164,790 | 14% | $326,900 | 12% | $811,760 | 8% | |||
| 3500 Regular CAB 4X4 | $68,740 | 10% | $68,740 | 10% | $34,370 | 10% | $171,850 | 10% | $103,110 | 12% | $137,480 | 13% | $137,480 | 9% | $378,070 | 11% | $549,920 | 11% | |||
| 2500 Mega CAB 4X4 | $42,460 | 15% | $42,460 | 0% | $127,380 | 7% | $212,300 | 7% | $127,380 | 10% | $127,380 | 5% | $127,380 | 7% | $382,140 | 7% | $594,440 | 7% | |||
| 1500 Regular CAB 4X4 | $32,825 | 10% | $98,475 | 7% | $131,300 | 8% | $164,125 | 11% | $164,125 | 8% | $328,250 | 10% | $459,550 | 9% | |||||||
| RAM Total | $42,460 | 15% | $101,565 | 10% | $111,200 | 7% | $260,225 | 7% | $515,450 | 8% | $394,615 | 11% | $428,985 | 9% | $264,860 | 8% | $1,088,460 | 9% | $1,603,910 | 9% | |
| Outback | $29,290 | 0% | $146,450 | 3% | $58,580 | 15% | $234,320 | 6% | $117,160 | 6% | $29,290 | 5% | $117,160 | 11% | $263,610 | 8% | $497,930 | 7% | |||
| Impreza | $19,165 | 0% | $38,330 | 8% | $76,660 | 8% | $134,155 | 6% | $76,660 | 5% | $57,495 | 7% | $38,330 | 5% | $172,485 | 6% | $306,640 | 6% | |||
| Forester | $22,090 | 15% | $44,180 | 0% | $22,090 | 15% | $88,360 | 8% | $110,450 | 12% | $132,540 | 4% | $22,090 | 0% | $265,080 | 7% | $353,440 | 7% | |||
| Subaru Total | $70,545 | 5% | $228,960 | 3% | $157,330 | 11% | $456,835 | 6% | $304,270 | 8% | $219,325 | 5% | $177,580 | 8% | $701,175 | 7% | $1,158,010 | 7% | |||
| Grand Vitara | $133,995 | 4% | $26,799 | 0% | $26,799 | 10% | $187,593 | 4% | $80,397 | 3% | $53,598 | 15% | $53,598 | 3% | $187,593 | 6% | $375,186 | 5% | |||
| Venza | $86,085 | 8% | $28,695 | 10% | $57,390 | 13% | $172,170 | 10% | $57,390 | 8% | $86,085 | 8% | $57,390 | 5% | $200,865 | 7% | $373,035 | 8% | |||
| Tundra 4x4 Reg. Cab | $63,290 | 5% | $126,580 | 8% | $189,870 | 7% | $94,935 | 3% | $94,935 | 10% | $63,290 | 10% | $253,160 | 8% | $443,030 | 7% | |||||
| Sienna | $30,980 | 10% | $123,920 | 9% | $123,920 | 1% | $92,940 | 5% | $371,760 | 5% | $92,940 | 3% | $154,900 | 8% | $247,840 | 6% | $619,600 | 6% | |||
| Sequoia | $173,800 | 6% | $260,700 | 3% | $434,500 | 4% | $86,900 | 5% | $43,450 | 10% | $130,350 | 7% | $564,850 | 5% | |||||||
| Camry | $31,260 | 10% | $31,260 | 15% | $125,040 | 6% | $187,560 | 8% | $62,520 | 15% | $125,040 | 6% | $62,520 | 8% | $250,080 | 9% | $437,640 | 9% | |||
| Avalon | $31,785 | 10% | $63,570 | 0% | $95,355 | 12% | $190,710 | 8% | $190,710 | 8% | $63,570 | 5% | $95,355 | 10% | $349,635 | 8% | $540,345 | 8% | |||
| Toyota Total | $94,025 | 10% | $447,375 | 7% | $507,865 | 4% | $497,305 | 8% | $1,546,570 | 7% | $585,395 | 7% | $567,980 | 8% | $278,555 | 8% | $1,431,930 | 8% | $2,978,500 | 7% | |
| Touareg | $96,640 | 10% | $96,640 | 10% | $193,280 | 10% | $144,960 | 8% | $96,640 | 8% | $241,600 | 8% | $434,880 | 9% | |||||||
| Tiguan | $47,640 | 3% | $95,280 | 10% | $71,460 | 13% | $214,380 | 9% | $95,280 | 6% | $71,460 | 8% | $47,640 | 5% | $214,380 | 7% | $428,760 | 8% | |||
| Jetta | $118,860 | 9% | $19,810 | 0% | $138,670 | 8% | $19,810 | 0% | $19,810 | 5% | $118,860 | 8% | $158,480 | 7% | $297,150 | 7% | |||||
| Golf | $56,670 | 7% | $37,780 | 8% | $94,450 | 4% | $188,900 | 6% | $18,890 | 15% | $18,890 | 5% | $56,670 | 7% | $94,450 | 8% | $283,350 | 6% | |||
| Volkswagen Total | $319,810 | 8% | $249,510 | 8% | $165,910 | 8% | $735,230 | 8% | $278,940 | 7% | $110,160 | 7% | $319,810 | 7% | $708,910 | 7% | $1,444,140 | 8% | |||
| Grand Total | $922,585 | 9% | $7,422,975 | 7% | $7,119,509 | 6% | $7,858,784 | 7% | $23,323,853 | 7% | $9,492,572 | 7% | $6,911,338 | 9% | $6,990,223 | 7% | $23,394,133 | 8% | $46,717,986 | 7% | |
Our new Blazor Pivot Table UI component (Community Technology Preview) summarizes data from the underlying data source and presents results using a cross-tabulated UI metaphor. It ships with the following integrated features/capabilities:
- High-performance data engine
- Data sorting support
- Data filters
- DateTime, numeric, alphabetic, and custom group intervals
- Configurable totals and grand totals
- Field customization in the UI
- Built-in scroll bar and sticky Header/Row Value areas
- Virtual scrolling support
- Value formatting and integrated templates
- Persistent layout
In this demo, the Pivot Table allows you to browse/analyze prices and discounts across different car models (by quarter/year). It also calculates and displays sub-totals and grand totals for relevant data points.