Spreadsheet: 200022d1355393118-a-better-pivot-table-a-better-pivot-table
Sheet: Sheet1

Product A
TM Name | 2011 | 2012 | 2012 % Contribution | 2013 Model Quota | [NAME] | $ Growth | % Growth | SDM Adjust
KatieCantlon | 370154 | 384129 | 0.08407996734240027 | 435659.3418257115 | 435659.3418257115 | 51530.34182571154 | 0.1341485329816585 | 0
[NAME] | 347120 | 456576 | 0.0999375084133813 | 517825.0005946337 | 517825.0005946337 | 61249.00059463375 | 0.1341485329816585 | 0
[NAME] | 323636 | 485848 | 0.106344701840711 | 551023.7964520729 | 551023.7964520729 | 65175.79645207291 | 0.1341485329816587 | 0
[NAME] | 279208.8 | 248775 | 0.05445304539778466 | 282147.8012925121 | 282147.8012925121 | 33372.8012925121 | 0.1341485329816585 | 0
[NAME] | 357595 | 560816 | 0.1227540512825003 | 636048.6436726418 | 636048.6436726418 | 75232.64367264183 | 0.1341485329816585 | 0
[NAME] | 249525 | 504897 | 0.1105142368091862 | 572628.1918568404 | 572628.1918568404 | 67731.19185684039 | 0.1341485329816585 | 0
[NAME] | 296360 | 498664 | 0.1091499283699765 | 565559.0440507658 | 565559.0440507658 | 66895.0440507658 | 0.1341485329816585 | 0
[NAME] | 381602 | 498022 | 0.1090094043818532 | 564830.9206925916 | 564830.9206925916 | 66808.92069259158 | 0.1341485329816585 | 0
[NAME] | 11004 | 49776 | 0.0108952056586077 | 56453.37737769503 | 56453.37737769503 | 6677.377377695033 | 0.1341485329816585 | 0
[NAME] | 165388 | 130514 | 0.02856751991577316 | 148022.2616335682 | 148022.2616335682 | 17508.26163356818 | 0.1341485329816585 | 0
[NAME] | 677908 | 750598 | 0.1642944305878259 | 851289.620558967 | 851289.620558967 | 100691.620558967 | 0.1341485329816585 | 0
 | 3459500.8 | 4568615 | 1 | 5181488.000008 | 5181488.000007999 | 612873.0000080002 | 0.4977559768183895 | 2.220446049250313e-16
Product B
TM Name | 2011 | 2012 | 2012 % Contribution | 2013 Model Quota | [NAME] | $ Growth | % Growth | SDM Adjust
KatieCantlon | 16188 | 8507 | 0.005581585164937908 | 6932.663669973941 | 6932.663669973941 | -1574.336330026059 | -0.1850636334813752 | 0
[NAME] | 17072 | 22800 | 0.01495946182679961 | 18580.54915662465 | 18580.54915662465 | -4219.450843375354 | -0.1850636334813752 | 0
[NAME] | 145893 | 202500 | 0.132863641224865 | 165024.6142200216 | 165024.6142200216 | -37475.38577997845 | -0.185063633481375 | 0
[NAME] | 29140 | 56890 | 0.03732648172485219 | 46361.72989124457 | 46361.72989124457 | -10528.27010875543 | -0.1850636334813751 | 0
[NAME] | 584 | 554 | 0.000363488677721359 | 451.4747470513182 | 451.4747470513182 | -102.5252529486818 | -0.1850636334813751 | 0
[NAME]
[NAME] | 317684 | 277696 | 0.182200996116445 | 226304.569236756 | 226304.569236756 | -51391.43076324396 | -0.1850636334813752 | 0
[NAME] | 433506 | 448704 | 0.2944022087514164 | 365665.207402373 | 365665.207402373 | -83038.79259762698 | -0.1850636334813752 | 0
[NAME] | 29460 | 16952 | 0.01112249109157487 | 13814.80128522373 | 13814.80128522373 | -3137.19871477627 | -0.1850636334813751 | 0
[NAME] | 1025 | 1994 | 0.001308296793098177 | 1624.983114838138 | 1624.983114838138 | -369.0168851618619 | -0.1850636334813751 | 0
[NAME] | 391246 | 487522 | 0.3198713486282895 | 397299.407277893 | 397299.407277893 | -90222.59272210696 | -0.1850636334813751 | 0
 | 1381798 | 1524119 | 1 | 1242060.000002 | 1242060.000002 | -139737.999998 | -0.1011276612051834 | 0
Product C
TM Name | 2011 | 2012 | 2012 % Contribution | 2013 Model Quota | [NAME] | $ Growth | % Growth | SDM Adjust
KatieCantlon | 127269 | 117210 | 0.1441254226867507 | 119117.8386641466 | 119117.8386641466 | 1907.838664146577 | 0.01627709806455568 | 0
[NAME] | 133374 | 58554 | 0.072 | 59507.089200072 | 59507.089200072 | 953.0892000719978 | 0.01627709806455568 | 0
[NAME] | 253308 | 242980 | 0.2987765139870888 | 246935.0092877258 | 246935.0092877258 | 3955.009287725756 | 0.01627709806455568 | 0
[NAME] | 58730 | 34670 | 0.04263141715339686 | 35234.32698989815 | 35234.32698989815 | 564.3269898981453 | 0.01627709806455568 | 0
[NAME] | 49300 | 41614 | 0.05116999692591454 | 42291.35515885842 | 42291.35515885842 | 677.3551588584232 | 0.01627709806455568 | 0
[NAME] | 181256 | 43916 | 0.05400061481709192 | 44630.82503860303 | 44630.82503860303 | 714.825038603034 | 0.01627709806455591 | 0
[NAME] | 335760.36 | 186050 | 0.2287734399016293 | 189078.3540949106 | 189078.3540949106 | 3028.35409491061 | 0.01627709806455591 | 0
[NAME] | 78376 | 65688 | 0.08077221026744544 | 66757.21001766455 | 66757.21001766455 | 1069.210017664547 | 0.01627709806455591 | 0
[NAME]
[NAME]
[NAME] | 12012 | 22568 | 0.02775038426068245 | 22935.34154912089 | 22935.34154912089 | 367.3415491208943 | 0.01627709806455568 | 0
 | 1229385.36 | 813250 | 1 | 826487.350001 | 826487.3500009999 | -402898.009999 | -0.327723123365484 | 1.110223024625157e-16