Available in the Full Version

Data Grid - Custom Summaries

Product ID
Product Name
Product Number
Make Flag
1Adjustable RaceAR-5381false
2Bearing BallBA-8327false
3BB Ball BearingBE-2349true
4Headset Ball BearingsBE-2908false
316BladeBL-2036true
317LL CrankarmCA-5965false
318ML CrankarmCA-6738false
319HL CrankarmCA-7457false
320Chainring BoltsCB-2903false
321Chainring NutCN-6137false
322ChainringCR-7833false
323Crown RaceCR-9981false
324Chain StaysCS-2812true
325Decal 1DC-8732false
326Decal 2DC-9824false
327Down TubeDT-2377true
328Mountain End CapsEC-M092true
329Road End CapsEC-R098true
330Touring End CapsEC-T209true
331Fork EndFE-3760true
332FreewheelFH-2981false
341Flat Washer 1FW-1000false
342Flat Washer 6FW-1200false
343Flat Washer 2FW-1400false
344Flat Washer 9FW-3400false
345Flat Washer 4FW-3800false
346Flat Washer 3FW-5160false
347Flat Washer 8FW-5800false
348Flat Washer 5FW-7160false
349Flat Washer 7FW-9160false
350Fork CrownFC-3654true
351Front Derailleur CageFC-3982false
352Front Derailleur LinkageFL-2301false
355Guide PulleyGP-0982false
356LL Grip TapeGT-0820false
357ML Grip TapeGT-1209false
358HL Grip TapeGT-2908false
359Thin-Jam Hex Nut 9HJ-1213false
360Thin-Jam Hex Nut 10HJ-1220false
361Thin-Jam Hex Nut 1HJ-1420false
362Thin-Jam Hex Nut 2HJ-1428false
363Thin-Jam Hex Nut 15HJ-3410false
364Thin-Jam Hex Nut 16HJ-3416false
365Thin-Jam Hex Nut 5HJ-3816false
366Thin-Jam Hex Nut 6HJ-3824false
367Thin-Jam Hex Nut 3HJ-5161false
368Thin-Jam Hex Nut 4HJ-5162false
369Thin-Jam Hex Nut 13HJ-5811false
370Thin-Jam Hex Nut 14HJ-5818false
371Thin-Jam Hex Nut 7HJ-7161false
372Thin-Jam Hex Nut 8HJ-7162false
373Thin-Jam Hex Nut 12HJ-9080false
374Thin-Jam Hex Nut 11HJ-9161false
375Hex Nut 5HN-1024false
376Hex Nut 6HN-1032false
377Hex Nut 16HN-1213false
378Hex Nut 17HN-1220false
379Hex Nut 7HN-1224false
380Hex Nut 8HN-1420false
381Hex Nut 9HN-1428false
382Hex Nut 22HN-3410false
383Hex Nut 23HN-3416false
384Hex Nut 12HN-3816false
385Hex Nut 13HN-3824false
386Hex Nut 1HN-4402false
387Hex Nut 10HN-5161false
388Hex Nut 11HN-5162false
389Hex Nut 2HN-5400false
390Hex Nut 20HN-5811false
391Hex Nut 21HN-5818false
392Hex Nut 3HN-6320false
393Hex Nut 14HN-7161false
394Hex Nut 15HN-7162false
395Hex Nut 4HN-8320false
396Hex Nut 18HN-9161false
397Hex Nut 19HN-9168false
398Handlebar TubeHT-2981true
399Head TubeHT-8019true
400LL HubHU-6280true
401HL HubHU-8998true
402Keyed WasherKW-4091false
403External Lock Washer 3LE-1000false
404External Lock Washer 4LE-1200false
405External Lock Washer 9LE-1201false
406External Lock Washer 5LE-1400false
407External Lock Washer 7LE-3800false
408External Lock Washer 6LE-5160false
409External Lock Washer 1LE-6000false
410External Lock Washer 8LE-7160false
411External Lock Washer 2LE-8000false
412Internal Lock Washer 3LI-1000false
413Internal Lock Washer 4LI-1200false
414Internal Lock Washer 9LI-1201false
415Internal Lock Washer 5LI-1400false
416Internal Lock Washer 7LI-3800false
417Internal Lock Washer 6LI-5160false
418Internal Lock Washer 10LI-5800false
419Internal Lock Washer 1LI-6000false
420Internal Lock Washer 8LI-7160false
421Internal Lock Washer 2LI-8000false
422Thin-Jam Lock Nut 9LJ-1213false
423Thin-Jam Lock Nut 10LJ-1220false
424Thin-Jam Lock Nut 1LJ-1420false
425Thin-Jam Lock Nut 2LJ-1428false
426Thin-Jam Lock Nut 15LJ-3410false
427Thin-Jam Lock Nut 16LJ-3416false
428Thin-Jam Lock Nut 5LJ-3816false
429Thin-Jam Lock Nut 6LJ-3824false
430Thin-Jam Lock Nut 3LJ-5161false
431Thin-Jam Lock Nut 4LJ-5162false
432Thin-Jam Lock Nut 13LJ-5811false
433Thin-Jam Lock Nut 14LJ-5818false
434Thin-Jam Lock Nut 7LJ-7161false
435Thin-Jam Lock Nut 8LJ-7162false
436Thin-Jam Lock Nut 12LJ-9080false
437Thin-Jam Lock Nut 11LJ-9161false
438Lock Nut 5LN-1024false
439Lock Nut 6LN-1032false
440Lock Nut 16LN-1213false
441Lock Nut 17LN-1220false
442Lock Nut 7LN-1224false
443Lock Nut 8LN-1420false
444Lock Nut 9LN-1428false
445Lock Nut 22LN-3410false
446Lock Nut 23LN-3416false
447Lock Nut 12LN-3816false
448Lock Nut 13LN-3824false
449Lock Nut 1LN-4400false
450Lock Nut 10LN-5161false
451Lock Nut 11LN-5162false
452Lock Nut 2LN-5400false
453Lock Nut 20LN-5811false
454Lock Nut 21LN-5818false
455Lock Nut 3LN-6320false
456Lock Nut 14LN-7161false
457Lock Nut 15LN-7162false
458Lock Nut 4LN-8320false
459Lock Nut 19LN-9080false
460Lock Nut 18LN-9161false
461Lock RingLR-2398false
462Lower Head RaceLR-8520false
463Lock Washer 4LW-1000false
464Lock Washer 5LW-1200false
465Lock Washer 10LW-1201false
466Lock Washer 6LW-1400false
467Lock Washer 13LW-3400false
468Lock Washer 8LW-3800false
469Lock Washer 1LW-4000false
470Lock Washer 7LW-5160false
471Lock Washer 12LW-5800false
472Lock Washer 2LW-6000false
473Lock Washer 9LW-7160false
474Lock Washer 3LW-8000false
475Lock Washer 11LW-9160false
476Metal AngleMA-7075false
477Metal Bar 1MB-2024false
478Metal Bar 2MB-6061false
479Metal Plate 2MP-2066false
480Metal Plate 1MP-2503false
481Metal Plate 3MP-4960false
482Metal Sheet 2MS-0253false
483Metal Sheet 3MS-1256false
484Metal Sheet 7MS-1981false
485Metal Sheet 4MS-2259false
486Metal Sheet 5MS-2341false
487Metal Sheet 6MS-2348false
488Metal Sheet 1MS-6061false
489Metal Tread PlateMT-1000false
490LL NippleNI-4127false
491HL NippleNI-9522false
492Paint - BlackPA-187Bfalse
493Paint - RedPA-361Rfalse
494Paint - SilverPA-529Sfalse
495Paint - BluePA-632Ufalse
496Paint - YellowPA-823Yfalse
497Pinch BoltPB-6109false
504Cup-Shaped RaceRA-2345false
505Cone-Shaped RaceRA-7490false
506ReflectorRF-9198false
507LL Mountain RimRM-M464false
508ML Mountain RimRM-M692false
509HL Mountain RimRM-M823false
510LL Road RimRM-R436false
511ML Road RimRM-R600false
512HL Road RimRM-R800false
513Touring RimRM-T801false
514LL Mountain Seat AssemblySA-M198true
515ML Mountain Seat AssemblySA-M237true
516HL Mountain Seat AssemblySA-M687true
517LL Road Seat AssemblySA-R127true
518ML Road Seat AssemblySA-R430true
519HL Road Seat AssemblySA-R522true
520LL Touring Seat AssemblySA-T467true
521ML Touring Seat AssemblySA-T612true
522HL Touring Seat AssemblySA-T872true
523LL Spindle/AxleSD-2342false
524HL Spindle/AxleSD-9872false
525LL ShellSH-4562false
526HL ShellSH-9312false
527SpokesSK-9283false
528Seat LugSL-0931false
529StemSM-9087true
530Seat PostSP-2981false
531SteererSR-2098true
532Seat StaysSS-2985true
533Seat TubeST-9828true
534Top TubeTO-2301true
535Tension PulleyTP-0923false
679Rear Derailleur CageRC-0291false
680HL Road Frame - Black, 58FR-R92B-58true
706HL Road Frame - Red, 58FR-R92R-58true
707Sport-100 Helmet, RedHL-U509-Rfalse
708Sport-100 Helmet, BlackHL-U509false
709Mountain Bike Socks, MSO-B909-Mfalse
710Mountain Bike Socks, LSO-B909-Lfalse
711Sport-100 Helmet, BlueHL-U509-Bfalse
712AWC Logo CapCA-1098false
713Long-Sleeve Logo Jersey, SLJ-0192-Sfalse
714Long-Sleeve Logo Jersey, MLJ-0192-Mfalse
715Long-Sleeve Logo Jersey, LLJ-0192-Lfalse
716Long-Sleeve Logo Jersey, XLLJ-0192-Xfalse
717HL Road Frame - Red, 62FR-R92R-62true
718HL Road Frame - Red, 44FR-R92R-44true
719HL Road Frame - Red, 48FR-R92R-48true
720HL Road Frame - Red, 52FR-R92R-52true
721HL Road Frame - Red, 56FR-R92R-56true
722LL Road Frame - Black, 58FR-R38B-58true
723LL Road Frame - Black, 60FR-R38B-60true
724LL Road Frame - Black, 62FR-R38B-62true
725LL Road Frame - Red, 44FR-R38R-44true
726LL Road Frame - Red, 48FR-R38R-48true
727LL Road Frame - Red, 52FR-R38R-52true
728LL Road Frame - Red, 58FR-R38R-58true
729LL Road Frame - Red, 60FR-R38R-60true
730LL Road Frame - Red, 62FR-R38R-62true
731ML Road Frame - Red, 44FR-R72R-44true
732ML Road Frame - Red, 48FR-R72R-48true
733ML Road Frame - Red, 52FR-R72R-52true
734ML Road Frame - Red, 58FR-R72R-58true
735ML Road Frame - Red, 60FR-R72R-60true
736LL Road Frame - Black, 44FR-R38B-44true
737LL Road Frame - Black, 48FR-R38B-48true
738LL Road Frame - Black, 52FR-R38B-52true
739HL Mountain Frame - Silver, 42FR-M94S-42true
740HL Mountain Frame - Silver, 44FR-M94S-44true
741HL Mountain Frame - Silver, 48FR-M94S-52true
742HL Mountain Frame - Silver, 46FR-M94S-46true
743HL Mountain Frame - Black, 42FR-M94B-42true
744HL Mountain Frame - Black, 44FR-M94B-44true
745HL Mountain Frame - Black, 48FR-M94B-48true
746HL Mountain Frame - Black, 46FR-M94B-46true
747HL Mountain Frame - Black, 38FR-M94B-38true
748HL Mountain Frame - Silver, 38FR-M94S-38true
749Road-150 Red, 62BK-R93R-62true
750Road-150 Red, 44BK-R93R-44true
751Road-150 Red, 48BK-R93R-48true
752Road-150 Red, 52BK-R93R-52true
753Road-150 Red, 56BK-R93R-56true
754Road-450 Red, 58BK-R68R-58true
755Road-450 Red, 60BK-R68R-60true
756Road-450 Red, 44BK-R68R-44true
757Road-450 Red, 48BK-R68R-48true
758Road-450 Red, 52BK-R68R-52true
759Road-650 Red, 58BK-R50R-58true
760Road-650 Red, 60BK-R50R-60true
761Road-650 Red, 62BK-R50R-62true
762Road-650 Red, 44BK-R50R-44true
763Road-650 Red, 48BK-R50R-48true
764Road-650 Red, 52BK-R50R-52true
765Road-650 Black, 58BK-R50B-58true
766Road-650 Black, 60BK-R50B-60true
767Road-650 Black, 62BK-R50B-62true
768Road-650 Black, 44BK-R50B-44true
769Road-650 Black, 48BK-R50B-48true
770Road-650 Black, 52BK-R50B-52true
771Mountain-100 Silver, 38BK-M82S-38true
772Mountain-100 Silver, 42BK-M82S-42true
773Mountain-100 Silver, 44BK-M82S-44true
774Mountain-100 Silver, 48BK-M82S-48true
775Mountain-100 Black, 38BK-M82B-38true
776Mountain-100 Black, 42BK-M82B-42true
777Mountain-100 Black, 44BK-M82B-44true
778Mountain-100 Black, 48BK-M82B-48true
779Mountain-200 Silver, 38BK-M68S-38true
780Mountain-200 Silver, 42BK-M68S-42true
781Mountain-200 Silver, 46BK-M68S-46true
782Mountain-200 Black, 38BK-M68B-38true
783Mountain-200 Black, 42BK-M68B-42true
784Mountain-200 Black, 46BK-M68B-46true
785Mountain-300 Black, 38BK-M47B-38true
786Mountain-300 Black, 40BK-M47B-40true
787Mountain-300 Black, 44BK-M47B-44true
788Mountain-300 Black, 48BK-M47B-48true
789Road-250 Red, 44BK-R89R-44true
790Road-250 Red, 48BK-R89R-48true
791Road-250 Red, 52BK-R89R-52true
792Road-250 Red, 58BK-R89R-58true
793Road-250 Black, 44BK-R89B-44true
794Road-250 Black, 48BK-R89B-48true
795Road-250 Black, 52BK-R89B-52true
796Road-250 Black, 58BK-R89B-58true
797Road-550-W Yellow, 38BK-R64Y-38true
798Road-550-W Yellow, 40BK-R64Y-40true
799Road-550-W Yellow, 42BK-R64Y-42true
800Road-550-W Yellow, 44BK-R64Y-44true
801Road-550-W Yellow, 48BK-R64Y-48true
802LL ForkFK-1639true
803ML ForkFK-5136true
804HL ForkFK-9939true
805LL HeadsetHS-0296true
806ML HeadsetHS-2451true
807HL HeadsetHS-3479true
808LL Mountain HandlebarsHB-M243true
809ML Mountain HandlebarsHB-M763true
810HL Mountain HandlebarsHB-M918true
811LL Road HandlebarsHB-R504true
812ML Road HandlebarsHB-R720true
813HL Road HandlebarsHB-R956true
814ML Mountain Frame - Black, 38FR-M63B-38true
815LL Mountain Front WheelFW-M423true
816ML Mountain Front WheelFW-M762true
817HL Mountain Front WheelFW-M928true
818LL Road Front WheelFW-R623true
819ML Road Front WheelFW-R762true
820HL Road Front WheelFW-R820true
821Touring Front WheelFW-T905true
822ML Road Frame-W - Yellow, 38FR-R72Y-38true
823LL Mountain Rear WheelRW-M423true
824ML Mountain Rear WheelRW-M762true
825HL Mountain Rear WheelRW-M928true
826LL Road Rear WheelRW-R623true
827ML Road Rear WheelRW-R762true
828HL Road Rear WheelRW-R820true
829Touring Rear WheelRW-T905true
830ML Mountain Frame - Black, 40FR-M63B-40true
831ML Mountain Frame - Black, 44FR-M63B-44true
832ML Mountain Frame - Black, 48FR-M63B-48true
833ML Road Frame-W - Yellow, 40FR-R72Y-40true
834ML Road Frame-W - Yellow, 42FR-R72Y-42true
835ML Road Frame-W - Yellow, 44FR-R72Y-44true
836ML Road Frame-W - Yellow, 48FR-R72Y-48true
837HL Road Frame - Black, 62FR-R92B-62true
838HL Road Frame - Black, 44FR-R92B-44true
839HL Road Frame - Black, 48FR-R92B-48true
840HL Road Frame - Black, 52FR-R92B-52true
841Men's Sports Shorts, SSH-M897-Sfalse
842Touring-Panniers, LargePA-T100false
843Cable LockLO-C100false
844MinipumpPU-0452false
845Mountain PumpPU-M044false
846Taillights - Battery-PoweredLT-T990false
847Headlights - Dual-BeamLT-H902false
848Headlights - WeatherproofLT-H903false
849Men's Sports Shorts, MSH-M897-Mfalse
850Men's Sports Shorts, LSH-M897-Lfalse
851Men's Sports Shorts, XLSH-M897-Xfalse
852Women's Tights, STG-W091-Sfalse
853Women's Tights, MTG-W091-Mfalse
854Women's Tights, LTG-W091-Lfalse
855Men's Bib-Shorts, SSB-M891-Sfalse
856Men's Bib-Shorts, MSB-M891-Mfalse
857Men's Bib-Shorts, LSB-M891-Lfalse
858Half-Finger Gloves, SGL-H102-Sfalse
859Half-Finger Gloves, MGL-H102-Mfalse
860Half-Finger Gloves, LGL-H102-Lfalse
861Full-Finger Gloves, SGL-F110-Sfalse
862Full-Finger Gloves, MGL-F110-Mfalse
863Full-Finger Gloves, LGL-F110-Lfalse
864Classic Vest, SVE-C304-Sfalse
865Classic Vest, MVE-C304-Mfalse
866Classic Vest, LVE-C304-Lfalse
867Women's Mountain Shorts, SSH-W890-Sfalse
868Women's Mountain Shorts, MSH-W890-Mfalse
869Women's Mountain Shorts, LSH-W890-Lfalse
870Water Bottle - 30 oz.WB-H098false
871Mountain Bottle CageBC-M005false
872Road Bottle CageBC-R205false
873Patch Kit/8 PatchesPK-7098false
874Racing Socks, MSO-R809-Mfalse
875Racing Socks, LSO-R809-Lfalse
876Hitch Rack - 4-BikeRA-H123false
877Bike Wash - DissolverCL-9009false
878Fender Set - MountainFE-6654false
879All-Purpose Bike StandST-1401false
880Hydration Pack - 70 oz.HY-1023-70false
881Short-Sleeve Classic Jersey, SSJ-0194-Sfalse
882Short-Sleeve Classic Jersey, MSJ-0194-Mfalse
883Short-Sleeve Classic Jersey, LSJ-0194-Lfalse
884Short-Sleeve Classic Jersey, XLSJ-0194-Xfalse
885HL Touring Frame - Yellow, 60FR-T98Y-60true
886LL Touring Frame - Yellow, 62FR-T67Y-62true
887HL Touring Frame - Yellow, 46FR-T98Y-46true
888HL Touring Frame - Yellow, 50FR-T98Y-50true
889HL Touring Frame - Yellow, 54FR-T98Y-54true
890HL Touring Frame - Blue, 46FR-T98U-46true
891HL Touring Frame - Blue, 50FR-T98U-50true
892HL Touring Frame - Blue, 54FR-T98U-54true
893HL Touring Frame - Blue, 60FR-T98U-60true
894Rear DerailleurRD-2308true
895LL Touring Frame - Blue, 50FR-T67U-50true
896LL Touring Frame - Blue, 54FR-T67U-54true
897LL Touring Frame - Blue, 58FR-T67U-58true
898LL Touring Frame - Blue, 62FR-T67U-62true
899LL Touring Frame - Yellow, 44FR-T67Y-44true
900LL Touring Frame - Yellow, 50FR-T67Y-50true
901LL Touring Frame - Yellow, 54FR-T67Y-54true
902LL Touring Frame - Yellow, 58FR-T67Y-58true
903LL Touring Frame - Blue, 44FR-T67U-44true
904ML Mountain Frame-W - Silver, 40FR-M63S-40true
905ML Mountain Frame-W - Silver, 42FR-M63S-42true
906ML Mountain Frame-W - Silver, 46FR-M63S-46true
907Rear BrakesRB-9231false
908LL Mountain Seat/SaddleSE-M236false
909ML Mountain Seat/SaddleSE-M798false
910HL Mountain Seat/SaddleSE-M940false
911LL Road Seat/SaddleSE-R581false
912ML Road Seat/SaddleSE-R908false
913HL Road Seat/SaddleSE-R995false
914LL Touring Seat/SaddleSE-T312false
915ML Touring Seat/SaddleSE-T762false
916HL Touring Seat/SaddleSE-T924false
917LL Mountain Frame - Silver, 42FR-M21S-42true
918LL Mountain Frame - Silver, 44FR-M21S-44true
919LL Mountain Frame - Silver, 48FR-M21S-48true
920LL Mountain Frame - Silver, 52FR-M21S-52true
921Mountain Tire TubeTT-M928false
922Road Tire TubeTT-R982false
923Touring Tire TubeTT-T092false
924LL Mountain Frame - Black, 42FR-M21B-42true
925LL Mountain Frame - Black, 44FR-M21B-44true
926LL Mountain Frame - Black, 48FR-M21B-48true
927LL Mountain Frame - Black, 52FR-M21B-52true
928LL Mountain TireTI-M267false
929ML Mountain TireTI-M602false
930HL Mountain TireTI-M823false
931LL Road TireTI-R092false
932ML Road TireTI-R628false
933HL Road TireTI-R982false
934Touring TireTI-T723false
935LL Mountain PedalPD-M282false
936ML Mountain PedalPD-M340false
937HL Mountain PedalPD-M562false
938LL Road PedalPD-R347false
939ML Road PedalPD-R563false
940HL Road PedalPD-R853false
941Touring PedalPD-T852false
942ML Mountain Frame-W - Silver, 38FR-M63S-38true
943LL Mountain Frame - Black, 40FR-M21B-40true
944LL Mountain Frame - Silver, 40FR-M21S-40true
945Front DerailleurFD-2342true
946LL Touring HandlebarsHB-T721true
947HL Touring HandlebarsHB-T928true
948Front BrakesFB-9873false
949LL CranksetCS-4759true
950ML CranksetCS-6583true
951HL CranksetCS-9183true
952ChainCH-0234false
953Touring-2000 Blue, 60BK-T44U-60true
954Touring-1000 Yellow, 46BK-T79Y-46true
955Touring-1000 Yellow, 50BK-T79Y-50true
956Touring-1000 Yellow, 54BK-T79Y-54true
957Touring-1000 Yellow, 60BK-T79Y-60true
958Touring-3000 Blue, 54BK-T18U-54true
959Touring-3000 Blue, 58BK-T18U-58true
960Touring-3000 Blue, 62BK-T18U-62true
961Touring-3000 Yellow, 44BK-T18Y-44true
962Touring-3000 Yellow, 50BK-T18Y-50true
963Touring-3000 Yellow, 54BK-T18Y-54true
964Touring-3000 Yellow, 58BK-T18Y-58true
965Touring-3000 Yellow, 62BK-T18Y-62true
966Touring-1000 Blue, 46BK-T79U-46true
967Touring-1000 Blue, 50BK-T79U-50true
968Touring-1000 Blue, 54BK-T79U-54true
969Touring-1000 Blue, 60BK-T79U-60true
970Touring-2000 Blue, 46BK-T44U-46true
971Touring-2000 Blue, 50BK-T44U-50true
972Touring-2000 Blue, 54BK-T44U-54true
973Road-350-W Yellow, 40BK-R79Y-40true
974Road-350-W Yellow, 42BK-R79Y-42true
975Road-350-W Yellow, 44BK-R79Y-44true
976Road-350-W Yellow, 48BK-R79Y-48true
977Road-750 Black, 58BK-R19B-58true
978Touring-3000 Blue, 44BK-T18U-44true
979Touring-3000 Blue, 50BK-T18U-50true
980Mountain-400-W Silver, 38BK-M38S-38true
981Mountain-400-W Silver, 40BK-M38S-40true
982Mountain-400-W Silver, 42BK-M38S-42true
983Mountain-400-W Silver, 46BK-M38S-46true
984Mountain-500 Silver, 40BK-M18S-40true
985Mountain-500 Silver, 42BK-M18S-42true
986Mountain-500 Silver, 44BK-M18S-44true
987Mountain-500 Silver, 48BK-M18S-48true
988Mountain-500 Silver, 52BK-M18S-52true
989Mountain-500 Black, 40BK-M18B-40true
990Mountain-500 Black, 42BK-M18B-42true
991Mountain-500 Black, 44BK-M18B-44true
992Mountain-500 Black, 48BK-M18B-48true
993Mountain-500 Black, 52BK-M18B-52true
994LL Bottom BracketBB-7421true
995ML Bottom BracketBB-8107true
996HL Bottom BracketBB-9108true
997Road-750 Black, 44BK-R19B-44true
998Road-750 Black, 48BK-R19B-48true
999Road-750 Black, 52BK-R19B-52true

This sample is designed for a larger screen size.

On mobile, try rotating your screen, view full size, or email to another device.

This sample demonstrates how to create custom summaries for the igGrid control. When defining a custom method (SummaryOperand with type Custom) you point the summary feature to a custom function to calculate the row summary. When the compactRenderMode option is set to false, the results from both the predefined and the custom methods are positioned in summary rows according to their sort order as defined by the Order property in the igGridSummaries' defaultSummaryMethods option. The sample has two custom summary functions (countTrueValues, countFalseValues) each calculating the number of true or false values in a boolean column. Those summary functions are then used for the "Make Flag" column.

Code View

Copy to Clipboard
<!DOCTYPE html>
<html>
<head>
    <title></title>

    <!-- Ignite UI for jQuery Required Combined CSS Files -->
    <link href="http://cdn-na.infragistics.com/igniteui/2024.2/latest/css/themes/infragistics/infragistics.theme.css" rel="stylesheet" />
    <link href="http://cdn-na.infragistics.com/igniteui/2024.2/latest/css/structure/infragistics.css" rel="stylesheet" />

    <script src="http://ajax.aspnetcdn.com/ajax/modernizr/modernizr-2.8.3.js"></script>
    <script src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
    <script src="http://code.jquery.com/ui/1.11.1/jquery-ui.min.js"></script>

    <!-- Ignite UI for jQuery Required Combined JavaScript Files -->
    <script src="http://cdn-na.infragistics.com/igniteui/2024.2/latest/js/infragistics.core.js"></script>
    <script src="http://cdn-na.infragistics.com/igniteui/2024.2/latest/js/infragistics.lob.js"></script>
</head>
<body>
    <table id="grid"></table>
    <script src="/data-files/adventureworks.min.js"></script>
    <script>
        $(function () {
            $("#grid").igGrid({
                autoGenerateColumns: false,
                width: "100%",
                height: "400px",
                columns: [
                    { headerText: "Product ID", key: "ProductID", dataType: "number", width: "25%" },
                    { headerText: "Product Name", key: "Name", dataType: "string", width: "30%" },
                    { headerText: "Product Number", key: "ProductNumber", dataType: "string", width: "20%" },
                    { headerText: "Make Flag", key: "MakeFlag", dataType: "bool", width: "25%" }
                ],
                dataSource: adventureWorks,
                features: [
                    {
                        name: "Summaries",
                        columnSettings: [
                            {
                                columnKey: "MakeFlag",
                                summaryOperands: [
                                    {
                                        rowDisplayLabel: "Count True Values",
                                        type: "custom1",
                                        summaryCalculator: $.proxy(countTrueValues, this),
                                        order: 5
                                    },
                                    {
                                        rowDisplayLabel: "Count False Values",
                                        type: "custom2",
                                        summaryCalculator: $.proxy(countFalseValues, this),
                                        order: 6
                                    }
                                ]
                            }
                        ]
                    }
                ]
            });
        });

        function countTrueValues(data) {
            var i, l = data.length, count = 0, elem;
            for (i = 0; i < l; i++) {
                elem = data[i];
                if (elem === true) {
                    count++;
                }
            }
            return count;
        }

        function countFalseValues(data) {
            var i, l = data.length, count = 0, elem;
            for (i = 0; i < l; i++) {
                elem = data[i];
                if (elem === false) {
                    count++;
                }
            }
            return count;
        }
    </script>
</body>
</html>