Community Technology Preview (CTP)
|
|
|||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2024 Total | 2025 Total | Grand Total | |||||||||||||||||||
| Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | |||||||||||||||
| 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% | $58,095 | 5% | $116,190 | 3% | $348,570 | 8% | $116,190 | 8% | $116,190 | 8% | $522,855 | 8% | |||
| S8 | $110,895 | 5% | $332,685 | 7% | $887,160 | 6% | $221,790 | 5% | $221,790 | 8% | $1,663,425 | 6% | $332,685 | 7% | $332,685 | 7% | $2,107,005 | 6% | |||
| Q5 | $36,795 | 5% | $110,385 | 7% | $220,770 | 9% | $257,565 | 9% | $588,720 | 8% | $625,515 | 8% | |||||||||
| Allroad | $40,495 | 0% | $121,485 | 13% | $121,485 | 2% | $161,980 | 3% | $121,485 | 13% | $526,435 | 7% | $40,495 | 5% | $40,495 | 15% | $80,990 | 10% | $647,920 | 7% | |
| A6 | $43,095 | 5% | $43,095 | 5% | $129,285 | 5% | $129,285 | 5% | $172,380 | 5% | $474,045 | 5% | $129,285 | 12% | $43,095 | 10% | $172,380 | 11% | $689,520 | 7% | |
| Audi Total | $289,375 | 5% | $665,745 | 9% | $1,254,120 | 5% | $791,920 | 6% | $889,410 | 8% | $3,601,195 | 7% | $618,655 | 8% | $83,590 | 13% | $702,245 | 9% | $4,592,815 | 7% | |
| Z4 Sdrive35i | $224,300 | 1% | $168,225 | 5% | $56,075 | 10% | $168,225 | 5% | $56,075 | 5% | $448,600 | 6% | $672,900 | 4% | |||||||
| X6 | $71,325 | 5% | $285,300 | 11% | $285,300 | 6% | $142,650 | 10% | $142,650 | 13% | $855,900 | 10% | $71,325 | 10% | $71,325 | 10% | $998,550 | 9% | |||
| X3 | $79,550 | 8% | $119,325 | 7% | $79,550 | 3% | $39,775 | 0% | $79,550 | 0% | $318,200 | 3% | $79,550 | 13% | $79,550 | 13% | $477,300 | 5% | |||
| M5 | $182,250 | 10% | $91,125 | 15% | $364,500 | 3% | $182,250 | 8% | $91,125 | 0% | $729,000 | 5% | $182,250 | 0% | $91,125 | 10% | $273,375 | 3% | $1,184,625 | 5% | |
| 760li | $141,625 | 0% | $141,625 | 15% | $283,250 | 10% | $424,875 | 12% | $141,625 | 5% | $424,875 | 3% | $566,500 | 4% | $1,133,000 | 6% | |||||
| BMW Total | $699,050 | 5% | $663,975 | 9% | $927,050 | 5% | $816,150 | 7% | $369,400 | 5% | $2,776,575 | 7% | $474,750 | 7% | $516,000 | 5% | $990,750 | 6% | $4,466,375 | 6% | |
| Tahoe | $82,800 | 3% | $207,000 | 6% | $124,200 | 8% | $248,400 | 4% | $662,400 | 5% | $165,600 | 10% | $41,400 | 5% | $207,000 | 9% | $869,400 | 6% | |||
| Silverado 1500 Regular CAB 4WD | $134,600 | 6% | $33,650 | 0% | $33,650 | 15% | $67,300 | 8% | $33,650 | 5% | $67,300 | 5% | $100,950 | 5% | $302,850 | 6% | |||||
| Malibu | $22,805 | 15% | $45,610 | 5% | $45,610 | 3% | $45,610 | 10% | $136,830 | 6% | $45,610 | 10% | $45,610 | 10% | $205,245 | 8% | |||||
| Corvette Coupe | $490,380 | 6% | $245,190 | 5% | $367,785 | 13% | $735,570 | 6% | $1,838,925 | 7% | $612,975 | 9% | $612,975 | 9% | $2,451,900 | 8% | |||||
| Camaro | $55,250 | 10% | $165,750 | 0% | $276,250 | 10% | $386,750 | 8% | $828,750 | 7% | $55,250 | 15% | $55,250 | 15% | $939,250 | 8% | |||||
| Chevrolet Total | $212,655 | 8% | $618,790 | 5% | $697,200 | 3% | $813,845 | 10% | $1,404,370 | 7% | $3,534,205 | 6% | $913,085 | 10% | $108,700 | 5% | $1,021,785 | 9% | $4,768,645 | 7% | |
| Town & Country | $126,420 | 10% | $84,280 | 10% | $210,700 | 10% | $126,420 | 13% | $42,140 | 15% | $168,560 | 14% | $379,260 | 12% | |||||||
| 200 Convertible | $68,030 | 5% | $34,015 | 0% | $34,015 | 10% | $68,030 | 5% | $34,015 | 10% | $170,075 | 6% | $34,015 | 0% | $34,015 | 0% | $272,120 | 5% | |||
| Chrysler Total | $68,030 | 5% | $34,015 | 0% | $34,015 | 10% | $194,450 | 8% | $118,295 | 10% | $380,775 | 8% | $160,435 | 10% | $42,140 | 15% | $202,575 | 11% | $651,380 | 9% | |
| SRT Viper | $244,780 | 10% | $244,780 | 15% | $489,560 | 6% | $367,170 | 12% | $611,950 | 7% | $1,713,460 | 9% | $611,950 | 8% | $611,950 | 8% | $2,570,190 | 9% | |||
| Grand Caravan | $27,690 | 10% | $27,690 | 10% | $55,380 | 8% | $166,140 | 4% | $110,760 | 4% | $359,970 | 5% | $387,660 | 5% | |||||||
| Durango | $30,790 | 0% | $92,370 | 3% | $30,790 | 15% | $61,580 | 8% | $184,740 | 7% | $61,580 | 13% | $30,790 | 15% | $92,370 | 13% | $307,900 | 8% | |||
| Charger | $27,290 | 10% | $27,290 | 0% | $54,580 | 5% | $27,290 | 10% | $109,160 | 6% | $218,320 | 6% | $27,290 | 10% | $27,290 | 10% | $272,900 | 7% | |||
| Challenger | $45,190 | 0% | $135,570 | 0% | $225,950 | 9% | $45,190 | 15% | $225,950 | 5% | $632,660 | 6% | $90,380 | 13% | $90,380 | 13% | $768,230 | 6% | |||
| Dodge Total | $375,740 | 7% | $435,330 | 6% | $917,840 | 7% | $636,580 | 8% | $1,119,400 | 6% | $3,109,150 | 7% | $763,910 | 10% | $58,080 | 13% | $821,990 | 10% | $4,306,880 | 7% | |
| Taurus | $80,190 | 13% | $120,285 | 7% | $120,285 | 3% | $160,380 | 6% | $240,570 | 10% | $641,520 | 7% | $120,285 | 8% | $40,095 | 0% | $160,380 | 6% | $882,090 | 8% | |
| F-350 SD Supercab 4X4 | $96,100 | 0% | $240,250 | 7% | $144,150 | 7% | $144,150 | 5% | $48,050 | 10% | $576,600 | 7% | $192,200 | 5% | $48,050 | 0% | $240,250 | 4% | $912,950 | 5% | |
| F-150 Regular CAB 4X4 | $31,900 | 10% | $127,600 | 6% | $31,900 | 0% | $159,500 | 10% | $63,800 | 10% | $382,800 | 8% | $95,700 | 8% | $63,800 | 3% | $159,500 | 6% | $574,200 | 8% | |
| Expedition | $41,600 | 5% | $83,200 | 8% | $83,200 | 13% | $124,800 | 13% | $41,600 | 0% | $332,800 | 10% | $41,600 | 0% | $41,600 | 10% | $83,200 | 5% | $457,600 | 9% | |
| Edge | $95,985 | 2% | $95,985 | 8% | $63,990 | 13% | $63,990 | 5% | $223,965 | 9% | $63,990 | 5% | $31,995 | 5% | $95,985 | 5% | $415,935 | 6% | |||
| Ford Total | $345,775 | 5% | $667,320 | 7% | $443,525 | 7% | $652,820 | 8% | $394,020 | 9% | $2,157,685 | 8% | $513,775 | 6% | $225,540 | 3% | $739,315 | 5% | $3,242,775 | 7% | |
| Odyssey | $97,965 | 12% | $65,310 | 13% | $32,655 | 15% | $130,620 | 3% | $65,310 | 13% | $293,895 | 8% | $32,655 | 5% | $65,310 | 5% | $97,965 | 5% | $489,825 | 8% | |
| Crosstour | $28,060 | 15% | $56,120 | 8% | $56,120 | 10% | $56,120 | 15% | $56,120 | 10% | $224,480 | 11% | $140,300 | 10% | $84,180 | 7% | $224,480 | 9% | $477,020 | 10% | |
| Accord | $30,860 | 5% | $61,720 | 13% | $92,580 | 10% | $123,440 | 11% | $154,300 | 8% | $432,040 | 10% | $92,580 | 10% | $92,580 | 10% | $555,480 | 10% | |||
| Honda Total | $156,885 | 11% | $183,150 | 11% | $181,355 | 11% | $310,180 | 9% | $275,730 | 9% | $950,415 | 10% | $265,535 | 9% | $149,490 | 6% | $415,025 | 8% | $1,522,325 | 9% | |
| Sportage | $87,750 | 3% | $29,250 | 10% | $117,000 | 4% | $58,500 | 3% | $29,250 | 10% | $234,000 | 5% | $29,250 | 10% | $29,250 | 0% | $58,500 | 5% | $380,250 | 5% | |
| Soul | $41,400 | 10% | $62,100 | 2% | $103,500 | 7% | $103,500 | 11% | $269,100 | 7% | $41,400 | 8% | $41,400 | 3% | $82,800 | 5% | $393,300 | 7% | |||
| RIO | $17,300 | 15% | $17,300 | 15% | $86,500 | 11% | $69,200 | 4% | $190,300 | 9% | $17,300 | 15% | $51,900 | 2% | $69,200 | 5% | $259,500 | 8% | |||
| KIA Total | $129,150 | 6% | $108,650 | 6% | $134,300 | 6% | $248,500 | 8% | $201,950 | 8% | $693,400 | 7% | $87,950 | 10% | $122,550 | 2% | $210,500 | 5% | $1,033,050 | 7% | |
| Range Rover Supercharged | $399,980 | 5% | $499,975 | 7% | $199,990 | 10% | $199,990 | 3% | $899,955 | 7% | $199,990 | 3% | $299,985 | 8% | $499,975 | 6% | $1,799,910 | 6% | |||
| Range Rover Evoque | $84,080 | 5% | $84,080 | 5% | $210,200 | 10% | $42,040 | 15% | $126,120 | 3% | $462,440 | 8% | $84,080 | 8% | $84,080 | 8% | $630,600 | 7% | |||
| LR4 | $249,975 | 4% | $99,990 | 0% | $99,990 | 15% | $199,980 | 10% | $399,960 | 9% | $149,985 | 2% | $149,985 | 2% | $799,920 | 6% | |||||
| Land Rover Total | $734,035 | 5% | $684,045 | 5% | $410,190 | 10% | $342,020 | 10% | $326,100 | 7% | $1,762,355 | 8% | $434,055 | 4% | $299,985 | 8% | $734,040 | 5% | $3,230,430 | 6% | |
| RX 350 | $125,865 | 0% | $167,820 | 6% | $125,865 | 12% | $167,820 | 10% | $461,505 | 9% | $41,955 | 10% | $41,955 | 0% | $83,910 | 5% | $671,280 | 7% | |||
| LX 570 | $164,850 | 13% | $164,850 | 10% | $82,425 | 10% | $412,125 | 9% | $329,700 | 9% | $989,100 | 9% | $329,700 | 8% | $82,425 | 10% | $412,125 | 8% | $1,566,075 | 9% | |
| IS 350 | $87,350 | 13% | $43,675 | 15% | $87,350 | 8% | $174,700 | 5% | $218,375 | 7% | $524,100 | 7% | $87,350 | 10% | $87,350 | 10% | $698,800 | 8% | |||
| Lexus Total | $378,065 | 7% | $376,345 | 9% | $295,640 | 10% | $754,645 | 8% | $548,075 | 8% | $1,974,705 | 8% | $459,005 | 9% | $124,380 | 5% | $583,385 | 8% | $2,936,155 | 8% | |
| Mx-5 Miata | $122,575 | 7% | $98,060 | 8% | $49,030 | 0% | $73,545 | 3% | $343,210 | 5% | $49,030 | 0% | $49,030 | 0% | $392,240 | 5% | |||||
| Mazda6 | $21,520 | 15% | $43,040 | 0% | $43,040 | 0% | $129,120 | 9% | $172,160 | 9% | $387,360 | 7% | $21,520 | 15% | $21,520 | 10% | $43,040 | 13% | $451,920 | 8% | |
| Cx-5 | $43,580 | 15% | $87,160 | 8% | $152,530 | 2% | $130,740 | 7% | $65,370 | 5% | $435,800 | 5% | $21,790 | 10% | $21,790 | 10% | $43,580 | 10% | $522,960 | 6% | |
| Mazda Total | $65,100 | 15% | $252,775 | 6% | $293,630 | 3% | $308,890 | 7% | $311,075 | 7% | $1,166,370 | 6% | $43,310 | 13% | $92,340 | 5% | $135,650 | 8% | $1,367,120 | 6% | |
| Slk350 | $56,305 | 5% | $168,915 | 7% | $56,305 | 10% | $56,305 | 0% | $337,830 | 6% | $112,610 | 10% | $56,305 | 15% | $168,915 | 12% | $506,745 | 8% | |||
| S600 | $161,205 | 0% | $483,615 | 8% | $644,820 | 9% | $322,410 | 5% | $1,450,845 | 8% | $161,205 | 5% | $161,205 | 10% | $322,410 | 8% | $1,934,460 | 7% | |||
| Ml350 | $48,175 | 15% | $144,525 | 12% | $144,525 | 8% | $48,175 | 0% | $48,175 | 5% | $385,400 | 8% | $48,175 | 10% | $48,175 | 10% | $481,750 | 9% | |||
| G550 | $227,810 | 3% | $341,715 | 5% | $113,905 | 5% | $113,905 | 15% | $455,620 | 10% | $1,025,145 | 8% | $569,525 | 9% | $569,525 | 9% | $1,822,480 | 8% | |||
| Cls550 | $291,620 | 9% | $145,810 | 8% | $218,715 | 5% | $145,810 | 3% | $801,955 | 6% | $218,715 | 12% | $72,905 | 10% | $291,620 | 11% | $1,093,575 | 8% | |||
| Mercedes-Benz Total | $437,190 | 5% | $834,165 | 8% | $1,056,770 | 8% | $1,081,920 | 8% | $1,028,320 | 6% | $4,001,175 | 7% | $1,110,230 | 10% | $290,415 | 12% | $1,400,645 | 10% | $5,839,010 | 8% | |
| Outlander | $88,260 | 8% | $29,420 | 15% | $117,680 | 3% | $29,420 | 5% | $176,520 | 5% | $264,780 | 6% | |||||||||
| Lancer | $20,790 | 0% | $62,370 | 7% | $20,790 | 5% | $103,950 | 5% | $20,790 | 10% | $20,790 | 10% | $124,740 | 6% | |||||||
| Mitsubishi Total | $88,260 | 8% | $29,420 | 15% | $138,470 | 2% | $62,370 | 7% | $50,210 | 5% | $280,470 | 5% | $20,790 | 10% | $20,790 | 10% | $389,520 | 6% | |||
| Murano | $87,855 | 7% | $29,285 | 5% | $175,710 | 4% | $58,570 | 13% | $263,565 | 6% | $351,420 | 6% | |||||||||
| Maxima | $68,060 | 3% | $34,030 | 5% | $34,030 | 10% | $136,120 | 5% | $68,060 | 13% | $68,060 | 13% | $136,120 | 13% | $272,240 | 9% | |||||
| Altima | $31,350 | 15% | $31,350 | 10% | $62,700 | 8% | $125,400 | 10% | $62,700 | 15% | $62,700 | 15% | $188,100 | 12% | |||||||
| Nissan Total | $87,855 | 7% | $128,695 | 6% | $209,740 | 4% | $89,920 | 12% | $96,730 | 8% | $525,085 | 7% | $130,760 | 14% | $68,060 | 13% | $198,820 | 13% | $811,760 | 8% | |
| 3500 Regular CAB 4X4 | $137,480 | 10% | $103,110 | 10% | $68,740 | 15% | $309,330 | 11% | $206,220 | 12% | $34,370 | 0% | $240,590 | 10% | $549,920 | 11% | |||||
| 2500 Mega CAB 4X4 | $42,460 | 15% | $42,460 | 0% | $84,920 | 5% | $84,920 | 13% | $127,380 | 7% | $339,680 | 7% | $127,380 | 7% | $84,920 | 5% | $212,300 | 6% | $594,440 | 7% | |
| 1500 Regular CAB 4X4 | $32,825 | 10% | $98,475 | 7% | $98,475 | 8% | $98,475 | 13% | $328,250 | 10% | $131,300 | 8% | $131,300 | 8% | $459,550 | 9% | |||||
| RAM Total | $42,460 | 15% | $212,765 | 8% | $183,395 | 6% | $286,505 | 10% | $294,595 | 11% | $977,260 | 9% | $464,900 | 9% | $119,290 | 3% | $584,190 | 8% | $1,603,910 | 9% | |
| Outback | $175,740 | 3% | $29,290 | 15% | $87,870 | 10% | $58,580 | 5% | $351,480 | 6% | $117,160 | 9% | $29,290 | 15% | $146,450 | 10% | $497,930 | 7% | |||
| Impreza | $57,495 | 5% | $57,495 | 7% | $38,330 | 5% | $76,660 | 6% | $229,980 | 6% | $76,660 | 6% | $76,660 | 6% | $306,640 | 6% | |||||
| Forester | $22,090 | 15% | $22,090 | 0% | $22,090 | 0% | $44,180 | 15% | $132,540 | 11% | $220,900 | 10% | $110,450 | 1% | $110,450 | 1% | $353,440 | 7% | |||
| Subaru Total | $22,090 | 15% | $255,325 | 3% | $108,875 | 7% | $170,380 | 10% | $267,780 | 8% | $802,360 | 7% | $304,270 | 5% | $29,290 | 15% | $333,560 | 6% | $1,158,010 | 7% | |
| Grand Vitara | $80,397 | 7% | $80,397 | 0% | $26,799 | 10% | $26,799 | 10% | $80,397 | 5% | $214,392 | 4% | $80,397 | 7% | $80,397 | 7% | $375,186 | 5% | |||
| Venza | $86,085 | 8% | $28,695 | 10% | $57,390 | 13% | $28,695 | 0% | $114,780 | 10% | $229,560 | 9% | $57,390 | 5% | $57,390 | 5% | $373,035 | 8% | |||
| Tundra 4x4 Reg. Cab | $63,290 | 5% | $63,290 | 8% | $126,580 | 4% | $94,935 | 8% | $348,095 | 6% | $63,290 | 10% | $31,645 | 15% | $94,935 | 12% | $443,030 | 7% | |||
| Sienna | $92,940 | 12% | $123,920 | 4% | $154,900 | 3% | $61,960 | 0% | $61,960 | 8% | $402,740 | 3% | $123,920 | 9% | $123,920 | 9% | $619,600 | 6% | |||
| Sequoia | $130,350 | 5% | $173,800 | 4% | $130,350 | 3% | $43,450 | 0% | $86,900 | 10% | $434,500 | 5% | $564,850 | 5% | |||||||
| Camry | $31,260 | 10% | $125,040 | 8% | $31,260 | 10% | $93,780 | 10% | $250,080 | 9% | $125,040 | 9% | $31,260 | 5% | $156,300 | 8% | $437,640 | 9% | |||
| Avalon | $63,570 | 5% | $31,785 | 0% | $286,065 | 9% | $317,850 | 9% | $127,140 | 6% | $31,785 | 15% | $158,925 | 8% | $540,345 | 8% | |||||
| Toyota Total | $404,205 | 8% | $421,490 | 4% | $530,970 | 6% | $578,010 | 6% | $452,355 | 9% | $1,982,825 | 6% | $496,780 | 8% | $94,690 | 12% | $591,470 | 8% | $2,978,500 | 7% | |
| Touareg | $144,960 | 8% | $48,320 | 15% | $96,640 | 5% | $48,320 | 15% | $338,240 | 9% | $96,640 | 8% | $96,640 | 8% | $434,880 | 9% | |||||
| Tiguan | $47,640 | 3% | $47,640 | 13% | $71,460 | 10% | $71,460 | 10% | $95,280 | 9% | $285,840 | 10% | $95,280 | 5% | $95,280 | 5% | $428,760 | 8% | |||
| Jetta | $79,240 | 10% | $39,620 | 8% | $19,810 | 0% | $19,810 | 0% | $19,810 | 5% | $99,050 | 4% | $79,240 | 10% | $39,620 | 5% | $118,860 | 8% | $297,150 | 7% | |
| Golf | $56,670 | 7% | $18,890 | 0% | $94,450 | 4% | $37,780 | 15% | $18,890 | 5% | $170,010 | 6% | $37,780 | 8% | $18,890 | 5% | $56,670 | 7% | $283,350 | 6% | |
| Volkswagen Total | $183,550 | 7% | $251,110 | 8% | $234,040 | 7% | $225,690 | 9% | $182,300 | 9% | $893,140 | 8% | $308,940 | 8% | $58,510 | 5% | $367,450 | 7% | $1,444,140 | 8% | |
| Grand Total | $4,799,867 | 7% | $6,903,507 | 7% | $8,077,924 | 6% | $8,391,594 | 8% | $8,410,512 | 8% | $31,783,537 | 7% | $7,651,532 | 8% | $2,483,050 | 7% | $10,134,582 | 8% | $46,717,986 | 7% | |
Our new Blazor Pivot Table UI component (Community Technology Preview - official ship date June 2025) 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
- 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/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.