Spreadsheet: 219614d1362818699-table-without-using-pivot-workbook-1-1
Sheet: Output

1. Dynamic Volume Table by BU (Dropdown)
 | The Table should look like this one, except not being a Pivot, formulas only.
 | Thanks
 | Bu_desc | (All)
 | Sum of SU | Column Labels
 | ROPM | 201201 | 201202 | 201203 | 201204 | 201205 | 201206 | 201207 | 201208 | 201209 | 201210 | 201211 | 201212 | 201301 | (blank) | Grand Total
 | Avittal, [NAME] | 18073.66 | 20319.21 | 20720.67 | 19582.42 | 20555.94 | 21719.88 | 19570.12 | 23100.99 | 19073.54 | 20981.82 | 19714.58 | 23085.35 | 19588.95 |  | 266087.13
 | Bannister, [NAME] | 18641.95 | 20170.26 | 24491.35 | 20888.54 | 23117.19 | 21573.24 | 21531.01 | 23621.02 | 19960.26 | 24196.27 | 22194.15 | 20205.68 | 20125.01 |  | 280715.93
 | Batcheller, Laurel | 18622.73 | 20422.35 | 24529.94 | 19798.5 | 24453.14 | 21974.67 | 21990.73 | 24559.05 | 24000.81 | 21791.52 | 20610.27 | 20701.89 | 18911.01 |  | 282366.61
 | Berdoll, [NAME] | 24162.48 | 22969.52 | 32521.33 | 24101.7 | 25445.45 | 20811.61 | 23733.12 | 22401.35 | 19334.1 | 24879.38 | 20676.7 | 24018.54 | 23634.68 |  | 308689.96
 | Blake, Misty | 19590.26 | 22536.24 | 28718.65 | 22035.74 | 25150.16 | 23885.35 | 22734.18 | 25581.93 | 21085.56 | 20621.26 | 19322.24 | 20292.21 | 18347.78 |  | 289901.5599999999
 | Camarlinghi, Jenae | 13045.64 | 14398.82 | 16511.3 | 19042.26 | 16797.96 | 14867.29 | 15900.64 | 18351.49 | 15365.3 | 15519 | 16317.46 | 12977.07 | 12872.86 |  | 201967.09
 | Craig, [NAME] | 23072.95 | 25470.85 | 28940.14 | 24599.02 | 28220.49 | 24474.23000000001 | 25136.47 | 27272.07 | 22057.01000000001 | 26467.04 | 21875.24 | 20915.78 | 21779.68 |  | 320280.9700000001
 | [NAME], [NAME] | 15420.33 | 16135.02 | 18140.01 | 17148.03 | 19544.16 | 17351.56 | 16835.81 | 19194.43 | 16743.37 | 17876.89 | 17657 | 19278.46 | 13158.66 |  | 224483.73
 | [NAME], [NAME] | 20124.36 | 18730.06 | 23499.11 | 22581.41 | 23670.94 | 20750.37 | 27514.34999999999 | 23942.53 | 20532.76 | 19292.98 | 19036.54 | 19967.81 | 10960.87 |  | 270604.09
 | Erichsen, Brice | 12515.71 | 12578.47 | 13613.79 | 13044.03 | 15153.8 | 14185.47 | 13814.33 | 14792.3 | 12235.55 | 14967 | 12596.45 | 14351.29 | 12479.31 |  | 176327.5
 | Haro, [NAME] | 26704 | 28227.5 | 34667.5 | 29794 | 40866 | 34733 | 30327 | 33145 | 28889 | 32179 | 25876 | 25667.5 | 23325 |  | 394400.5
 | Lewis, [NAME] | 9285.220000000001 | 10606.04 | 10487.82 | 9454.64 | 11750.97 | 10574.63 | 10051.91 | 11251.3 | 9833.92 | 11390.23 | 10375.41 | 11031.32 | 9552.15 |  | 135645.56
 | NULL | 165032 | 181817.3 | 208325.21 | 184685.7 | 215075.4 | 202556.86 | 195531.47 | 218850.8 | 178266.43 | 201483.06 | 188111.2900000001 | 183267.92 | 177052.92 |  | 2500056.36
 | Rexing, Scott | 8567.54 | 8803.62 | 10104.6 | 9028.970000000001 | 10596.76 | 9936.56 | 9828.330000000002 | 10173.45 | 9802.49 | 10793.42 | 9602.619999999999 | 11231.62 | 8375.34 |  | 126845.32
 | [NAME], [NAME] | 4956.64 | 5697.1 | 6851.06 | 6322.66 | 8392.29 | 8471.470000000001 | 8195.279999999999 | 8987.869999999999 | 6164.290000000001 | 5723.35 | 6280.89 | 6080.47 | 4845.07 |  | 86968.44
 | Scrivner, Braden | 25071.67 | 26054.97 | 30146.8 | 22935.82 | 27191.29 | 24614 | 26328.24 | 28608.24 | 23305.93 | 26071.07 | 23419.92000000001 | 29726.09 | 24162.31 |  | 337636.35
 | Sparks, [NAME] | 14535.91 | 17747.78 | 19786.07 | 17220.04 | 20600.26 | 21069.01 | 21050.44 | 21226.57 | 19542.45 | 20860.1 | 18809.41 | 20939.58 | 14089.9 |  | 247477.52
 | Spohr, [NAME] | 17533.23 | 18984.11 | 21106.42 | 18862.24 | 22984.8 | 20500.17 | 21663.24 | 23595.25 | 17828.23 | 20158.64 | 18323.22 | 17038.26 | 18327.22 |  | 256905.03
 | Thimsen, George | 12492.99 | 12722.37 | 13777.84 | 12713.23 | 14659.75 | 13764.98 | 14444.73 | 16922.64 | 12641.72 | 14877.46 | 13590.67 | 13158.66 | 11551.4 |  | 177318.44
 | Tierney, [NAME] | 20785.78 | 22147.93 | 27761.85 | 22662.35 | 28685.03 | 26910.88 | 25830.87 | 28366.38 | 23360.67 | 25357.48 | 24867.5 | 22504.99 | 22025.19 |  | 321266.9
 | Vanderleeden, Christine | 25893.27 | 27272.1 | 29838.85 | 26502.73 | 29617.76000000001 | 25969.44 | 26707.37 | 28867.05 | 26546.44 | 29874.43 | 27465.92 | 27574.15 | 25915.38 |  | 358044.89
 | (blank) |  |  |  |  |  |  |  |  |  |  |  |  |  | 1477318.630000001 | 1477318.630000001
 | Grand Total | 514128.3199999999 | 553811.62 | 644540.3099999999 | 563004.0299999999 | 652529.54 | 600694.67 | 598719.64 | 652811.7100000001 | 546569.83 | 605361.3999999999 | 556723.48 | 564014.6400000001 | 511080.6900000001 | 1477318.630000001 | 9041308.510000002