Community Technology Preview (CTP)
|
Model Price
Discount
|
Sales Date
Quarter
|
||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Trademark
|
Name
|
2024 Total | 2025 Total | Grand Total | |||||||||||||||||
| Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |||||||||||||||
| 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% | $58,095 | 15% | $174,285 | 13% | $58,095 | 5% | $116,190 | 5% | $116,190 | 8% | $58,095 | 0% | $348,570 | 5% | $522,855 | 8% | |||
| S8 | $110,895 | 5% | $221,790 | 8% | $998,055 | 6% | $1,330,740 | 6% | $110,895 | 0% | $332,685 | 8% | $110,895 | 0% | $221,790 | 10% | $776,265 | 6% | $2,107,005 | 6% | |
| Q5 | $110,385 | 7% | $36,795 | 5% | $147,180 | 6% | $220,770 | 9% | $220,770 | 8% | $36,795 | 15% | $478,335 | 9% | $625,515 | 8% | |||||
| Allroad | $40,495 | 0% | $80,990 | 13% | $161,980 | 5% | $283,465 | 6% | $40,495 | 5% | $202,475 | 6% | $80,990 | 10% | $40,495 | 15% | $364,455 | 8% | $647,920 | 7% | |
| A6 | $43,095 | 5% | $43,095 | 5% | $86,190 | 3% | $172,380 | 4% | $172,380 | 6% | $129,285 | 7% | $172,380 | 9% | $43,095 | 10% | $517,140 | 8% | $689,520 | 7% | |
| Audi Total | $194,485 | 3% | $572,450 | 9% | $1,341,115 | 6% | $2,108,050 | 7% | $602,635 | 7% | $1,001,405 | 7% | $517,250 | 9% | $363,475 | 9% | $2,484,765 | 7% | $4,592,815 | 7% | |
| Z4 Sdrive35i | $168,225 | 2% | $224,300 | 4% | $56,075 | 10% | $448,600 | 4% | $168,225 | 5% | $56,075 | 5% | $224,300 | 5% | $672,900 | 4% | |||||
| X6 | $71,325 | 5% | $285,300 | 11% | $142,650 | 5% | $499,275 | 9% | $285,300 | 9% | $142,650 | 13% | $71,325 | 10% | $499,275 | 10% | $998,550 | 9% | |||
| X3 | $79,550 | 8% | $79,550 | 5% | $119,325 | 5% | $278,425 | 6% | $39,775 | 0% | $79,550 | 0% | $79,550 | 13% | $198,875 | 5% | $477,300 | 5% | |||
| M5 | $182,250 | 10% | $91,125 | 15% | $364,500 | 3% | $637,875 | 6% | $182,250 | 8% | $91,125 | 0% | $182,250 | 0% | $91,125 | 10% | $546,750 | 4% | $1,184,625 | 5% | |
| 760li | $141,625 | 0% | $141,625 | 15% | $283,250 | 8% | $283,250 | 10% | $566,500 | 4% | $849,750 | 6% | $1,133,000 | 6% | |||||||
| BMW Total | $642,975 | 5% | $680,275 | 8% | $824,175 | 5% | $2,147,425 | 6% | $958,800 | 7% | $369,400 | 5% | $333,125 | 7% | $657,625 | 5% | $2,318,950 | 6% | $4,466,375 | 6% | |
| Tahoe | $82,800 | 3% | $82,800 | 5% | $165,600 | 4% | $207,000 | 6% | $289,800 | 6% | $165,600 | 10% | $41,400 | 5% | $703,800 | 7% | $869,400 | 6% | |||
| Silverado 1500 Regular CAB 4WD | $33,650 | 5% | $100,950 | 7% | $33,650 | 0% | $168,250 | 5% | $67,300 | 10% | $67,300 | 5% | $134,600 | 8% | $302,850 | 6% | |||||
| Malibu | $22,805 | 15% | $22,805 | 0% | $45,610 | 5% | $91,220 | 6% | $68,415 | 8% | $22,805 | 10% | $22,805 | 10% | $114,025 | 9% | $205,245 | 8% | |||
| Corvette Coupe | $490,380 | 6% | $245,190 | 5% | $735,570 | 6% | $122,595 | 10% | $980,760 | 8% | $245,190 | 10% | $367,785 | 8% | $1,716,330 | 9% | $2,451,900 | 8% | |||
| Camaro | $55,250 | 10% | $165,750 | 0% | $221,000 | 3% | $221,000 | 13% | $386,750 | 6% | $55,250 | 10% | $55,250 | 15% | $718,250 | 9% | $939,250 | 8% | |||
| Chevrolet Total | $111,705 | 10% | $696,935 | 5% | $573,000 | 3% | $1,381,640 | 5% | $619,010 | 9% | $1,657,310 | 7% | $556,145 | 10% | $554,540 | 8% | $3,387,005 | 8% | $4,768,645 | 7% | |
| Town & Country | $126,420 | 10% | $42,140 | 15% | $126,420 | 12% | $84,280 | 13% | $379,260 | 12% | $379,260 | 12% | |||||||||
| 200 Convertible | $68,030 | 5% | $34,015 | 0% | $34,015 | 10% | $136,060 | 5% | $34,015 | 5% | $34,015 | 5% | $68,030 | 5% | $136,060 | 5% | $272,120 | 5% | |||
| Chrysler Total | $68,030 | 5% | $34,015 | 0% | $34,015 | 10% | $136,060 | 5% | $160,435 | 9% | $76,155 | 10% | $194,450 | 9% | $84,280 | 13% | $515,320 | 10% | $651,380 | 9% | |
| SRT Viper | $244,780 | 10% | $244,780 | 15% | $489,560 | 6% | $979,120 | 9% | $367,170 | 12% | $489,560 | 5% | $611,950 | 10% | $122,390 | 5% | $1,591,070 | 8% | $2,570,190 | 9% | |
| Grand Caravan | $27,690 | 10% | $27,690 | 10% | $27,690 | 5% | $83,070 | 8% | $110,760 | 8% | $166,140 | 3% | $27,690 | 0% | $304,590 | 5% | $387,660 | 5% | |||
| Durango | $30,790 | 0% | $92,370 | 3% | $123,160 | 3% | $30,790 | 15% | $30,790 | 5% | $92,370 | 12% | $30,790 | 15% | $184,740 | 12% | $307,900 | 8% | |||
| Charger | $27,290 | 10% | $27,290 | 0% | $54,580 | 5% | $109,160 | 5% | $27,290 | 10% | $81,870 | 7% | $27,290 | 5% | $27,290 | 10% | $163,740 | 8% | $272,900 | 7% | |
| Challenger | $45,190 | 0% | $135,570 | 0% | $180,760 | 9% | $361,520 | 4% | $90,380 | 13% | $180,760 | 6% | $135,570 | 8% | $406,710 | 8% | $768,230 | 6% | |||
| Dodge Total | $344,950 | 8% | $466,120 | 5% | $844,960 | 6% | $1,656,030 | 6% | $626,390 | 10% | $949,120 | 5% | $894,870 | 9% | $180,470 | 10% | $2,650,850 | 8% | $4,306,880 | 7% | |
| Taurus | $200,475 | 9% | $120,285 | 3% | $320,760 | 7% | $120,285 | 8% | $280,665 | 9% | $120,285 | 8% | $40,095 | 0% | $561,330 | 8% | $882,090 | 8% | |||
| F-350 SD Supercab 4X4 | $96,100 | 0% | $192,200 | 8% | $96,100 | 5% | $384,400 | 5% | $192,200 | 8% | $96,100 | 5% | $192,200 | 5% | $48,050 | 0% | $528,550 | 5% | $912,950 | 5% | |
| F-150 Regular CAB 4X4 | $127,600 | 8% | $31,900 | 5% | $159,500 | 7% | $159,500 | 8% | $63,800 | 8% | $95,700 | 10% | $95,700 | 5% | $414,700 | 8% | $574,200 | 8% | |||
| Expedition | $83,200 | 3% | $124,800 | 13% | $208,000 | 9% | $124,800 | 13% | $41,600 | 0% | $41,600 | 0% | $41,600 | 10% | $249,600 | 8% | $457,600 | 9% | |||
| Edge | $63,990 | 3% | $95,985 | 7% | $95,985 | 10% | $255,960 | 7% | $31,995 | 5% | $31,995 | 5% | $63,990 | 5% | $31,995 | 5% | $159,975 | 5% | $415,935 | 6% | |
| Ford Total | $160,090 | 1% | $699,460 | 7% | $469,070 | 8% | $1,328,620 | 7% | $628,780 | 9% | $514,160 | 7% | $513,775 | 7% | $257,440 | 4% | $1,914,155 | 7% | $3,242,775 | 7% | |
| Odyssey | $32,655 | 15% | $130,620 | 11% | $32,655 | 15% | $195,930 | 13% | $97,965 | 2% | $65,310 | 8% | $32,655 | 15% | $97,965 | 5% | $293,895 | 6% | $489,825 | 8% | |
| Crosstour | $28,060 | 15% | $56,120 | 8% | $56,120 | 10% | $140,300 | 10% | $56,120 | 15% | $56,120 | 10% | $84,180 | 10% | $140,300 | 8% | $336,720 | 10% | $477,020 | 10% | |
| Accord | $92,580 | 10% | $61,720 | 8% | $154,300 | 9% | $123,440 | 13% | $154,300 | 8% | $61,720 | 13% | $61,720 | 8% | $401,180 | 10% | $555,480 | 10% | |||
| Honda Total | $60,715 | 15% | $279,320 | 10% | $150,495 | 10% | $490,530 | 11% | $277,525 | 9% | $275,730 | 8% | $178,555 | 12% | $299,985 | 7% | $1,031,795 | 9% | $1,522,325 | 9% | |
| Sportage | $87,750 | 3% | $29,250 | 10% | $117,000 | 4% | $234,000 | 4% | $58,500 | 3% | $58,500 | 10% | $29,250 | 0% | $146,250 | 5% | $380,250 | 5% | |||
| Soul | $20,700 | 10% | $82,800 | 4% | $103,500 | 5% | $62,100 | 7% | $82,800 | 10% | $62,100 | 10% | $82,800 | 5% | $289,800 | 8% | $393,300 | 7% | |||
| RIO | $17,300 | 15% | $17,300 | 15% | $34,600 | 15% | $69,200 | 13% | $86,500 | 4% | $69,200 | 5% | $224,900 | 7% | $259,500 | 8% | |||||
| KIA Total | $108,450 | 5% | $129,350 | 7% | $134,300 | 6% | $372,100 | 6% | $189,800 | 8% | $169,300 | 7% | $120,600 | 10% | $181,250 | 4% | $660,950 | 7% | $1,033,050 | 7% | |
| Range Rover Supercharged | $299,985 | 7% | $399,980 | 5% | $399,980 | 9% | $1,099,945 | 7% | $199,990 | 3% | $199,990 | 3% | $299,985 | 8% | $699,965 | 5% | $1,799,910 | 6% | |||
| Range Rover Evoque | $84,080 | 5% | $84,080 | 5% | $84,080 | 13% | $252,240 | 8% | $168,160 | 10% | $126,120 | 3% | $84,080 | 8% | $378,360 | 7% | $630,600 | 7% | |||
| LR4 | $199,980 | 5% | $99,990 | 0% | $49,995 | 0% | $349,965 | 3% | $99,990 | 15% | $99,990 | 5% | $249,975 | 7% | $449,955 | 8% | $799,920 | 6% | |||
| Land Rover Total | $584,045 | 6% | $584,050 | 4% | $534,055 | 9% | $1,702,150 | 6% | $468,140 | 9% | $226,110 | 4% | $534,045 | 6% | $299,985 | 8% | $1,528,280 | 7% | $3,230,430 | 6% | |
| RX 350 | $41,955 | 0% | $209,775 | 3% | $167,820 | 11% | $419,550 | 6% | $167,820 | 10% | $41,955 | 10% | $41,955 | 0% | $251,730 | 8% | $671,280 | 7% | |||
| LX 570 | $164,850 | 13% | $164,850 | 10% | $329,700 | 11% | $329,700 | 9% | $329,700 | 10% | $412,125 | 9% | $164,850 | 5% | $1,236,375 | 9% | $1,566,075 | 9% | |||
| IS 350 | $43,675 | 15% | $87,350 | 13% | $87,350 | 8% | $218,375 | 11% | $131,025 | 5% | $262,050 | 7% | $87,350 | 10% | $480,425 | 7% | $698,800 | 8% | |||
| Lexus Total | $250,480 | 10% | $461,975 | 7% | $255,170 | 10% | $967,625 | 8% | $628,545 | 8% | $591,750 | 8% | $541,430 | 9% | $206,805 | 3% | $1,968,530 | 8% | $2,936,155 | 8% | |
| Mx-5 Miata | $73,545 | 8% | $147,090 | 7% | $220,635 | 7% | $49,030 | 0% | $73,545 | 3% | $49,030 | 0% | $171,605 | 1% | $392,240 | 5% | |||||
| Mazda6 | $21,520 | 15% | $21,520 | 0% | $64,560 | 0% | $107,600 | 3% | $107,600 | 11% | $172,160 | 8% | $43,040 | 13% | $21,520 | 10% | $344,320 | 10% | $451,920 | 8% | |
| Cx-5 | $87,160 | 11% | $174,320 | 3% | $261,480 | 6% | $130,740 | 5% | $87,160 | 8% | $21,790 | 10% | $21,790 | 10% | $261,480 | 7% | $522,960 | 6% | |||
| Mazda Total | $21,520 | 15% | $182,225 | 9% | $385,970 | 4% | $589,715 | 6% | $287,370 | 7% | $332,865 | 7% | $64,830 | 12% | $92,340 | 5% | $777,405 | 7% | $1,367,120 | 6% | |
| Slk350 | $56,305 | 5% | $56,305 | 10% | $112,610 | 8% | $168,915 | 7% | $168,915 | 7% | $56,305 | 15% | $394,135 | 8% | $506,745 | 8% | |||||
| S600 | $161,205 | 0% | $322,410 | 8% | $483,615 | 5% | $483,615 | 7% | $644,820 | 9% | $161,205 | 5% | $161,205 | 10% | $1,450,845 | 8% | $1,934,460 | 7% | |||
| Ml350 | $192,700 | 13% | $96,350 | 13% | $289,050 | 13% | $96,350 | 0% | $48,175 | 5% | $48,175 | 10% | $192,700 | 4% | $481,750 | 9% | |||||
| G550 | $227,810 | 3% | $227,810 | 5% | $227,810 | 5% | $683,430 | 4% | $113,905 | 15% | $341,715 | 13% | $569,525 | 9% | $113,905 | 0% | $1,139,050 | 10% | $1,822,480 | 8% | |
| Cls550 | $218,715 | 8% | $218,715 | 8% | $437,430 | 8% | $72,905 | 0% | $291,620 | 5% | $218,715 | 12% | $72,905 | 10% | $656,145 | 7% | $1,093,575 | 8% | |||
| Mercedes-Benz Total | $389,015 | 2% | $695,530 | 9% | $921,590 | 9% | $2,006,135 | 8% | $935,690 | 6% | $1,326,330 | 8% | $1,166,535 | 9% | $404,320 | 9% | $3,832,875 | 8% | $5,839,010 | 8% | |
| Outlander | $29,420 | 5% | $88,260 | 12% | $58,840 | 3% | $176,520 | 8% | $58,840 | 3% | $29,420 | 5% | $88,260 | 3% | $264,780 | 6% | |||||
| Lancer | $20,790 | 0% | $20,790 | 0% | $41,580 | 5% | $41,580 | 8% | $20,790 | 10% | $103,950 | 7% | $124,740 | 6% | |||||||
| Mitsubishi Total | $29,420 | 5% | $88,260 | 12% | $79,630 | 2% | $197,310 | 6% | $100,420 | 4% | $71,000 | 7% | $20,790 | 10% | $192,210 | 6% | $389,520 | 6% | |||
| Murano | $58,570 | 3% | $58,570 | 10% | $175,710 | 4% | $292,850 | 5% | $58,570 | 13% | $58,570 | 13% | $351,420 | 6% | |||||||
| Maxima | $34,030 | 5% | $68,060 | 3% | $102,090 | 3% | $102,090 | 12% | $68,060 | 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 | $58,570 | 3% | $123,950 | 10% | $243,770 | 4% | $426,290 | 5% | $89,920 | 12% | $62,700 | 8% | $102,090 | 12% | $130,760 | 14% | $385,470 | 12% | $811,760 | 8% | |
| 3500 Regular CAB 4X4 | $103,110 | 10% | $34,370 | 10% | $137,480 | 10% | $68,740 | 10% | $103,110 | 13% | $137,480 | 13% | $103,110 | 7% | $412,440 | 11% | $549,920 | 11% | |||
| 2500 Mega CAB 4X4 | $42,460 | 15% | $42,460 | 0% | $42,460 | 10% | $127,380 | 8% | $127,380 | 8% | $127,380 | 7% | $84,920 | 5% | $127,380 | 7% | $467,060 | 7% | $594,440 | 7% | |
| 1500 Regular CAB 4X4 | $32,825 | 10% | $65,650 | 10% | $98,475 | 10% | $131,300 | 6% | $65,650 | 15% | $164,125 | 8% | $361,075 | 9% | $459,550 | 9% | |||||
| RAM Total | $42,460 | 15% | $178,395 | 8% | $142,480 | 10% | $363,335 | 10% | $327,420 | 8% | $296,140 | 11% | $386,525 | 9% | $230,490 | 7% | $1,240,575 | 9% | $1,603,910 | 9% | |
| Outback | $87,870 | 2% | $117,160 | 6% | $205,030 | 4% | $58,580 | 13% | $87,870 | 5% | $58,580 | 5% | $87,870 | 13% | $292,900 | 9% | $497,930 | 7% | |||
| Impreza | $57,495 | 5% | $57,495 | 7% | $114,990 | 6% | $38,330 | 5% | $76,660 | 6% | $57,495 | 5% | $19,165 | 10% | $191,650 | 6% | $306,640 | 6% | |||
| Forester | $22,090 | 15% | $22,090 | 0% | $22,090 | 0% | $66,270 | 5% | $44,180 | 15% | $132,540 | 11% | $110,450 | 1% | $287,170 | 8% | $353,440 | 7% | |||
| Subaru Total | $22,090 | 15% | $167,455 | 3% | $196,745 | 6% | $386,290 | 5% | $141,090 | 11% | $297,070 | 8% | $226,525 | 3% | $107,035 | 13% | $771,720 | 8% | $1,158,010 | 7% | |
| Grand Vitara | $80,397 | 7% | $53,598 | 0% | $26,799 | 0% | $160,794 | 3% | $26,799 | 10% | $107,196 | 6% | $53,598 | 10% | $26,799 | 0% | $214,392 | 7% | $375,186 | 5% | |
| Venza | $57,390 | 5% | $57,390 | 13% | $57,390 | 13% | $172,170 | 10% | $57,390 | 8% | $114,780 | 9% | $28,695 | 0% | $200,865 | 7% | $373,035 | 8% | |||
| Tundra 4x4 Reg. Cab | $126,580 | 6% | $126,580 | 6% | $126,580 | 4% | $63,290 | 13% | $94,935 | 7% | $31,645 | 15% | $316,450 | 8% | $443,030 | 7% | |||||
| Sienna | $61,960 | 10% | $92,940 | 8% | $185,880 | 3% | $340,780 | 6% | $61,960 | 0% | $61,960 | 5% | $154,900 | 8% | $278,820 | 6% | $619,600 | 6% | |||
| Sequoia | $43,450 | 10% | $217,250 | 4% | $173,800 | 3% | $434,500 | 4% | $43,450 | 0% | $86,900 | 10% | $130,350 | 7% | $564,850 | 5% | |||||
| Camry | $31,260 | 10% | $93,780 | 10% | $125,040 | 10% | $62,520 | 5% | $93,780 | 10% | $125,040 | 9% | $31,260 | 5% | $312,600 | 8% | $437,640 | 9% | |||
| Avalon | $63,570 | 5% | $31,785 | 0% | $95,355 | 3% | $190,710 | 10% | $95,355 | 8% | $95,355 | 7% | $63,570 | 10% | $444,990 | 9% | $540,345 | 8% | |||
| Toyota Total | $257,630 | 8% | $399,365 | 6% | $637,430 | 6% | $1,294,425 | 6% | $485,220 | 6% | $458,675 | 9% | $585,010 | 8% | $155,170 | 8% | $1,684,075 | 8% | $2,978,500 | 7% | |
| Touareg | $144,960 | 8% | $48,320 | 15% | $193,280 | 10% | $144,960 | 8% | $96,640 | 8% | $241,600 | 8% | $434,880 | 9% | |||||||
| Tiguan | $71,460 | 7% | $95,280 | 10% | $166,740 | 9% | $71,460 | 10% | $95,280 | 9% | $95,280 | 5% | $262,020 | 8% | $428,760 | 8% | |||||
| Jetta | $59,430 | 12% | $59,430 | 7% | $19,810 | 0% | $138,670 | 8% | $39,620 | 3% | $59,430 | 10% | $59,430 | 7% | $158,480 | 7% | $297,150 | 7% | |||
| Golf | $18,890 | 5% | $37,780 | 8% | $75,560 | 4% | $132,230 | 5% | $56,670 | 7% | $18,890 | 15% | $18,890 | 5% | $56,670 | 7% | $151,120 | 8% | $283,350 | 6% | |
| Volkswagen Total | $78,320 | 10% | $313,630 | 7% | $238,970 | 7% | $630,920 | 8% | $128,130 | 8% | $298,750 | 8% | $270,240 | 7% | $116,100 | 7% | $813,220 | 8% | $1,444,140 | 8% | |
| Grand Total | $3,505,347 | 7% | $6,806,358 | 7% | $8,033,739 | 6% | $18,345,444 | 7% | $7,682,119 | 8% | $9,081,166 | 7% | $7,260,388 | 8% | $4,348,869 | 7% | $28,372,542 | 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.