Spreadsheet: 180062d1347467989-help-with-of-in-pivot-table-pivot_help
Sheet: Pivot

Lead Source | Apollo |  |  |  |  |  |  | Want to be: | Want to be: | Want to be: | Want to be: | Want to be: | Want to be:
 | Values
Row Labels | Sum of Total Leads | Sum of Bad Leads | Sum of Net Leads | Sum of Contacted | Sum of Quoted | Sum of Gross Closed | Sum of Proj. Close | Average of Contact % | Average of Quoted % | Average of Contact to Quote % | Average of Quote to Close % | Average of Gross Closed % | Average of Proj. Close %
Arizona | 72 | 14 | 58 | 36 | 8 | 2 | 4.83 | 0.6206896551724138 | 0.1379310344827586 | 0.2222222222222222 | 0.25 | 0.03448275862068965 | 0.08327586206896552
Arkansas | 0 | 0 | 0 | 0 | 0 | 0 | 0
Colorado | 99 | 10 | 89 | 53 | 11 | 4 | 5.46 | 0.5955056179775281 | 0.1235955056179775 | 0.2075471698113208 | 0.3636363636363636 | 0.0449438202247191 | 0.06134831460674157
Georgia | 143 | 25 | 118 | 60 | 21 | 5 | 9.27 | 0.5084745762711864 | 0.1779661016949153 | 0.35 | 0.2380952380952381 | 0.0423728813559322 | 0.0785593220338983
Illinois | 53 | 6 | 47 | 29 | 10 | 3 | 4.9 | 0.6170212765957447 | 0.2127659574468085 | 0.3448275862068966 | 0.3 | 0.06382978723404255 | 0.1042553191489362
Indiana | 75 | 18 | 57 | 36 | 19 | 5 | 5.8 | 0.631578947368421 | 0.3333333333333333 | 0.5277777777777778 | 0.2631578947368421 | 0.08771929824561403 | 0.1017543859649123
Iowa | 12 | 3 | 9 | 6 | 0 | 0 | 0 | 0.6666666666666666
Kansas | 42 | 6 | 36 | 23 | 10 | 2 | 3.45 | 0.6388888888888888 | 0.2777777777777778 | 0.4347826086956522 | 0.2 | 0.05555555555555555 | 0.09583333333333334
Louisiana | 0 | 0 | 0 | 0 | 0 | 0 | 0
Michigan | 133 | 25 | 108 | 71 | 22 | 7 | 9.120000000000001 | 0.6574074074074074 | 0.2037037037037037 | 0.3098591549295774 | 0.3181818181818182 | 0.06481481481481481 | 0.08444444444444445
Mississippi | 0 | 0 | 0 | 0 | 0 | 0 | 0
Missouri | 60 | 14 | 46 | 31 | 11 | 3 | 3.85 | 0.6739130434782609 | 0.2391304347826087 | 0.3548387096774194 | 0.2727272727272727 | 0.06521739130434782 | 0.08369565217391305
Nebraska | 0 | 0 | 0 | 0 | 0 | 0 | 0
Nevada | 0 | 0 | 0 | 0 | 0 | 0 | 0
North Carolina | 109 | 20 | 89 | 56 | 21 | 9 | 12.15 | 0.6292134831460674 | 0.2359550561797753 | 0.375 | 0.4285714285714285 | 0.101123595505618 | 0.1365168539325843
Ohio | 119 | 27 | 92 | 53 | 24 | 2 | 3.72 | 0.5760869565217391 | 0.2608695652173913 | 0.4528301886792453 | 0.08333333333333333 | 0.02173913043478261 | 0.04043478260869565
Oklahoma | 22 | 5 | 17 | 13 | 8 | 2 | 2.2 | 0.7647058823529411 | 0.4705882352941176 | 0.6153846153846154 | 0.25 | 0.1176470588235294 | 0.1294117647058824
Pennsylvania | 191 | 28 | 163 | 91 | 30 | 7 | 8.66 | 0.558282208588957 | 0.1840490797546012 | 0.3296703296703297 | 0.2333333333333333 | 0.04294478527607362 | 0.05312883435582822
South Carolina | 29 | 7 | 22 | 14 | 6 | 2 | 3.06 | 0.6363636363636364 | 0.2727272727272727 | 0.4285714285714285 | 0.3333333333333333 | 0.09090909090909091 | 0.1390909090909091
Tennessee | 27 | 5 | 22 | 12 | 5 | 2 | 2 | 0.5454545454545454 | 0.2272727272727273 | 0.4166666666666667 | 0.4 | 0.09090909090909091 | 0.09090909090909091
Texas | 60 | 5 | 55 | 40 | 17 | 3 | 5.98 | 0.7272727272727273 | 0.3090909090909091 | 0.425 | 0.1764705882352941 | 0.05454545454545454 | 0.1087272727272727
Utah | 25 | 6 | 19 | 14 | 2 | 0 | 0 | 0.7368421052631579 | 0.1052631578947368 | 0.1428571428571428
Virginia | 52 | 8 | 44 | 29 | 11 | 3 | 3.8 | 0.6590909090909091 | 0.25 | 0.3793103448275862 | 0.2727272727272727 | 0.06818181818181818 | 0.08636363636363636
Grand Total | 1323 | 232 | 1091 | 667 | 236 | 61 | 88.25 | 0.6357476963267331 | 0.2365894030747891 | 0.3715968203516401 | 0.2739729923069706 | 0.06543352074632337 | 0.09235936115431527
 |  |  |  |  |  |  |  | Want to be: | Want to be: | Want to be: | Want to be: | Want to be: | Want to be: