Spreadsheet: 87821d1287679022-pivot-table-help-needed-lol
Sheet: Original

Loan ID | Customer Last Name | Branch | Loan Date | Loan Type | Annual Interest Rate | Loan Amount | Term (Years)
1044 | Heaney | Palmetto Bay | 2010-07-30 00:00:00 | Car | 0.0675 | 35000 | 3
1057 | Connolly | Palmetto Bay | 2010-09-25 00:00:00 | Personal | 0.0675 | 25000 | 5
1003 | Ellis | [NAME] | 2010-08-04 00:00:00 | Personal | 0.07 | 65625 | 4
1060 | Cifizzari | [NAME] | 2010-08-15 00:00:00 | Car | 0.0625 | 62500 | 3
1066 | Kiely | Palmetto Bay | 2010-08-19 00:00:00 | Personal | 0.07 | 70000 | 5
1072 | [NAME] | Palmetto Bay | 2010-08-17 00:00:00 | Other | 0.0625 | 57500 | 4
1081 | [NAME] | Palmetto Bay | 2010-08-19 00:00:00 | Car | 0.06 | 58625 | 3
1030 | Diller | [NAME] | 2010-07-20 00:00:00 | Car | 0.07 | 81250 | 6
1053 | Moreaux | Palmetto Bay | 2010-08-25 00:00:00 | Personal | 0.06 | 95000 | 5
1007 | Kinzer | Mangowood | 2010-07-10 00:00:00 | Car | 0.075 | 25000 | 3
1002 | [NAME] | Bay Heights | 2010-08-16 00:00:00 | Other | 0.0625 | 3750 | 1
1021 | [NAME] | Palmetto Bay | 2010-08-13 00:00:00 | Mortgage | 0.07 | 562500 | 30
1050 | Tanenbaum | Palmetto Bay | 2010-09-07 00:00:00 | Other | 0.075 | 50000 | 3
1087 | Ceres | Bay Heights | 2010-09-18 00:00:00 | Other | 0.0775 | 812500 | 15
1032 | Stoneburner | [NAME] | 2010-09-21 00:00:00 | Car | 0.0625 | 71000 | 4
1020 | Layton | Palmetto Bay | 2010-08-29 00:00:00 | Car | 0.0925 | 91500 | 4
1001 | Gette | Mangowood | 2010-08-10 00:00:00 | Mortgage | 0.07375000000000001 | 625000 | 30
1084 | Charette | Bay Heights | 2010-08-24 00:00:00 | Other | 0.075 | 12500 | 2
1043 | [NAME] | [NAME] | 2010-08-30 00:00:00 | Mortgage | 0.0625 | 710000 | 15
1035 | Squire | Palmetto Bay | 2010-09-01 00:00:00 | Other | 0.0625 | 13750 | 2
1055 | [NAME] | Bay Heights | 2010-08-05 00:00:00 | Mortgage | 0.07 | 243750 | 30
1070 | Clinger | Bay Heights | 2010-08-23 00:00:00 | Car | 0.0625 | 23750 | 5
1046 | Planes | Mangowood | 2010-09-04 00:00:00 | Mortgage | 0.065 | 586250 | 15
1040 | Waldron | Bay Heights | 2010-08-13 00:00:00 | Car | 0.085 | 26250 | 5
1085 | McNelly | Mangowood | 2010-08-27 00:00:00 | Mortgage | 0.08 | 361250 | 15
1045 | Crook | [NAME] | 2010-09-14 00:00:00 | Mortgage | 0.0625 | 981250 | 30
1058 | Lanahan | Palmetto Bay | 2010-07-23 00:00:00 | Other | 0.065 | 67500 | 5
1064 | Bland | [NAME] | 2010-07-14 00:00:00 | Car | 0.08750000000000001 | 112500 | 6
1078 | Del Cerro | Mangowood | 2010-08-15 00:00:00 | Mortgage | 0.0775 | 431250 | 15
1014 | Santiago | Mangowood | 2010-08-01 00:00:00 | Other | 0.0825 | 40000 | 4
1089 | Desjardins | [NAME] | 2010-07-23 00:00:00 | Personal | 0.08 | 62500 | 4
1037 | Black | Mangowood | 2010-07-19 00:00:00 | Car | 0.07 | 83750 | 4
1054 | Randall | [NAME] | 2010-09-21 00:00:00 | Mortgage | 0.08 | 700000 | 30
1036 | Hernandez | [NAME] | 2010-07-23 00:00:00 | Personal | 0.08 | 56250 | 5
1023 | [NAME] | Palmetto Bay | 2010-07-26 00:00:00 | Car | 0.0625 | 40000 | 4
1073 | Otis | Palmetto Bay | 2010-09-11 00:00:00 | Mortgage | 0.08 | 675000 | 15
1025 | Ellman | [NAME] | 2010-09-18 00:00:00 | Car | 0.07250000000000001 | 43750 | 5
1049 | [NAME] | Bay Heights | 2010-08-07 00:00:00 | Personal | 0.06 | 12500 | 3
1082 | Michaud | Palmetto Bay | 2010-07-30 00:00:00 | Personal | 0.0625 | 31250 | 2
1065 | Craven | Bay Heights | 2010-09-04 00:00:00 | Mortgage | 0.065 | 915000 | 30
1022 | Green | [NAME] | 2010-09-08 00:00:00 | Other | 0.08 | 512500 | 30
1008 | [NAME] | Mangowood | 2010-08-21 00:00:00 | Personal | 0.0825 | 78625 | 4
1041 | Lesperance | [NAME] | 2010-09-05 00:00:00 | Other | 0.085 | 35000 | 3
1013 | Lipten | Mangowood | 2010-07-25 00:00:00 | Mortgage | 0.07375000000000001 | 262500 | 30
1031 | Salamin | Bay Heights | 2010-07-27 00:00:00 | Mortgage | 0.0625 | 687500 | 30
1083 | [NAME] | Bay Heights | 2010-07-10 00:00:00 | Personal | 0.07 | 6250 | 1
1011 | [NAME] | Bay Heights | 2010-09-24 00:00:00 | Other | 0.075 | 78625 | 5
1012 | [NAME] | [NAME] | 2010-07-24 00:00:00 | Car | 0.07250000000000001 | 70000 | 6
1076 | Early | Bay Heights | 2010-09-14 00:00:00 | Personal | 0.08750000000000001 | 71125 | 5
1005 | Overby | [NAME] | 2010-07-10 00:00:00 | Mortgage | 0.07 | 837500 | 30
1048 | [NAME] | Bay Heights | 2010-07-13 00:00:00 | Other | 0.07 | 39375 | 4
1080 | [NAME] | Bay Heights | 2010-08-11 00:00:00 | Car | 0.07 | 53750 | 3
1034 | [NAME] | Mangowood | 2010-07-11 00:00:00 | Car | 0.0625 | 43125 | 4
1047 | Barbiarz | [NAME] | 2010-07-15 00:00:00 | Personal | 0.07 | 43750 | 3
1027 | [NAME] | Mangowood | 2010-08-24 00:00:00 | Other | 0.08 | 23750 | 2
1038 | Hecht | Palmetto Bay | 2010-07-28 00:00:00 | Personal | 0.082 | 18125 | 2
1059 | [NAME] | Mangowood | 2010-07-16 00:00:00 | Mortgage | 0.082 | 637500 | 15
1069 | Quackenbush | Bay Heights | 2010-09-03 00:00:00 | Other | 0.0625 | 15000 | 3
1006 | Recio | Palmetto Bay | 2010-07-22 00:00:00 | Car | 0.065 | 36125 | 5
1010 | [NAME] | Bay Heights | 2010-08-28 00:00:00 | Car | 0.0625 | 67500 | 5
1016 | Marsden | Mangowood | 2010-09-03 00:00:00 | Personal | 0.07 | 3750 | 3
1067 | Grauer | Mangowood | 2010-08-31 00:00:00 | Other | 0.08 | 56250 | 3
1028 | Olsen | Mangowood | 2010-09-06 00:00:00 | Car | 0.0625 | 59375 | 3
1017 | Perpall | Mangowood | 2010-08-15 00:00:00 | Personal | 0.07250000000000001 | 40000 | 2
1061 | Pelletier | Mangowood | 2010-08-25 00:00:00 | Mortgage | 0.082 | 400000 | 15
1051 | McDonald | Palmetto Bay | 2010-07-04 00:00:00 | Other | 0.065 | 15000 | 1
1039 | [NAME] | Palmetto Bay | 2010-07-08 00:00:00 | Other | 0.08 | 9375 | 4
1024 | Fletcher | [NAME] | 2010-09-06 00:00:00 | Mortgage | 0.07 | 593750 | 30
1052 | [NAME] | [NAME] | 2010-07-14 00:00:00 | Car | 0.08750000000000001 | 24375 | 3
1086 | Braunstein | Mangowood | 2010-08-23 00:00:00 | Personal | 0.0825 | 93750 | 4
1009 | [NAME] | Mangowood | 2010-08-08 00:00:00 | Personal | 0.0825 | 312500 | 10
1019 | Mendivil | Mangowood | 2010-09-10 00:00:00 | Other | 0.07 | 40000 | 4
1077 | Matos | Palmetto Bay | 2010-08-16 00:00:00 | Personal | 0.085 | 26250 | 3
1075 | Joncas | Mangowood | 2010-08-07 00:00:00 | Mortgage | 0.06 | 236250 | 30
1090 | [NAME] | [NAME] | 2010-07-10 00:00:00 | Mortgage | 0.065 | 437500 | 30
1026 | Blane | Mangowood | 2010-09-10 00:00:00 | Other | 0.0625 | 47500 | 4
1068 | [NAME] | Mangowood | 2010-09-08 00:00:00 | Personal | 0.07 | 56250 | 2
1018 | Center | Palmetto Bay | 2010-07-31 00:00:00 | Mortgage | 0.075 | 812500 | 30
1062 | [NAME] | Palmetto Bay | 2010-09-21 00:00:00 | Personal | 0.0925 | 23750 | 3
1088 | Aguiar | [NAME] | 2010-09-08 00:00:00 | Personal | 0.08 | 25000 | 5
1015 | Baer | Mangowood | 2010-07-17 00:00:00 | Mortgage | 0.0925 | 187500 | 15
1033 | Strickland | [NAME] | 2010-07-12 00:00:00 | Personal | 0.08 | 39375 | 2
1079 | Sales | Mangowood | 2010-07-25 00:00:00 | Mortgage | 0.08 | 437500 | 30
1071 | Marrero | Bay Heights | 2010-08-28 00:00:00 | Car | 0.065 | 34375 | 4
1074 | Gillespie | Bay Heights | 2010-08-03 00:00:00 | Car | 0.0775 | 98125 | 6
1029 | Fitzgerald | Bay Heights | 2010-07-20 00:00:00 | Car | 0.08750000000000001 | 108750 | 4
1042 | Fischer | Bay Heights | 2010-09-04 00:00:00 | Mortgage | 0.0625 | 1087500 | 30
1056 | [NAME] | [NAME] | 2010-07-27 00:00:00 | Other | 0.07 | 321250 | 3
1004 | [NAME] | Bay Heights | 2010-07-04 00:00:00 | Mortgage | 0.0625 | 537500 | 30
1063 | Feazel | Bay Heights | 2010-09-14 00:00:00 | Personal | 0.07375000000000001 | 68750 | 5