Spreadsheet: 200045d1355400152-a-better-pivot-table-ef_abetterpivottable_vks
Sheet: Sheet1

Product A |  |  |  |  |  |  |  |  |  |  | Product | TM Name | 2011 | 2012 | 2013 Model Quota | [NAME] | SDM Adjust
TM Name | 2011 | 2012 | 2012 % Contribution | 2013 Model Quota | [NAME] | $ Growth | % Growth | SDM Adjust |  |  | A | KatieCantlon | 370154 | 384129 | 435659.3418257115 | 435659.3418257115 | 0
KatieCantlon | 370154 | 384129 | 0.08407996734240027 | 435659.3418257115 | 435659.3418257115 | 51530.34182571154 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 347120 | 456576 | 517825.0005946337 | 517825.0005946337 | 0
[NAME] | 347120 | 456576 | 0.0999375084133813 | 517825.0005946337 | 517825.0005946337 | 61249.00059463375 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 323636 | 485848 | 551023.7964520729 | 551023.7964520729 | 0
[NAME] | 323636 | 485848 | 0.106344701840711 | 551023.7964520729 | 551023.7964520729 | 65175.79645207291 | 0.1341485329816587 | 0 |  |  | A | [NAME] | 279208.8 | 248775 | 282147.8012925121 | 282147.8012925121 | 0
[NAME] | 279208.8 | 248775 | 0.05445304539778466 | 282147.8012925121 | 282147.8012925121 | 33372.8012925121 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 357595 | 560816 | 636048.6436726418 | 636048.6436726418 | 0
[NAME] | 357595 | 560816 | 0.1227540512825003 | 636048.6436726418 | 636048.6436726418 | 75232.64367264183 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 249525 | 504897 | 572628.1918568404 | 572628.1918568404 | 0
[NAME] | 249525 | 504897 | 0.1105142368091862 | 572628.1918568404 | 572628.1918568404 | 67731.19185684039 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 296360 | 498664 | 565559.0440507658 | 565559.0440507658 | 0
[NAME] | 296360 | 498664 | 0.1091499283699765 | 565559.0440507658 | 565559.0440507658 | 66895.0440507658 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 381602 | 498022 | 564830.9206925916 | 564830.9206925916 | 0
[NAME] | 381602 | 498022 | 0.1090094043818532 | 564830.9206925916 | 564830.9206925916 | 66808.92069259158 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 11004 | 49776 | 56453.37737769503 | 56453.37737769503 | 0
[NAME] | 11004 | 49776 | 0.0108952056586077 | 56453.37737769503 | 56453.37737769503 | 6677.377377695033 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 165388 | 130514 | 148022.2616335682 | 148022.2616335682 | 0
[NAME] | 165388 | 130514 | 0.02856751991577316 | 148022.2616335682 | 148022.2616335682 | 17508.26163356818 | 0.1341485329816585 | 0 |  |  | A | [NAME] | 677908 | 750598 | 851289.620558967 | 851289.620558967 | 0
[NAME] | 677908 | 750598 | 0.1642944305878259 | 851289.620558967 | 851289.620558967 | 100691.620558967 | 0.1341485329816585 | 0 |  |  | B | KatieCantlon | 16188 | 8507 | 6932.663669973941 | 6932.663669973941 | 0
 |  |  |  |  |  |  |  |  |  |  | B | [NAME] | 17072 | 22800 | 18580.54915662465 | 18580.54915662465 | 0
 | 3459500.8 | 4568615 | 1 | 5181488.000008 | 5181488.000007999 | 612873.0000080002 | 0.4977559768183895 | 2.220446049250313e-16 |  |  | B | [NAME] | 145893 | 202500 | 165024.6142200216 | 165024.6142200216 | 0
 |  |  |  |  |  |  |  |  |  |  | B | [NAME] | 29140 | 56890 | 46361.72989124457 | 46361.72989124457 | 0
Product B |  |  |  |  |  |  |  |  |  |  | B | [NAME] | 584 | 554 | 451.4747470513182 | 451.4747470513182 | 0
TM Name | 2011 | 2012 | 2012 % Contribution | 2013 Model Quota | [NAME] | $ Growth | % Growth | SDM Adjust |  |  | B | [NAME]
KatieCantlon | 16188 | 8507 | 0.005581585164937908 | 6932.663669973941 | 6932.663669973941 | -1574.336330026059 | -0.1850636334813752 | 0 |  |  | B | [NAME] | 317684 | 277696 | 226304.569236756 | 226304.569236756 | 0
[NAME] | 17072 | 22800 | 0.01495946182679961 | 18580.54915662465 | 18580.54915662465 | -4219.450843375354 | -0.1850636334813752 | 0 |  |  | B | [NAME] | 433506 | 448704 | 365665.207402373 | 365665.207402373 | 0
[NAME] | 145893 | 202500 | 0.132863641224865 | 165024.6142200216 | 165024.6142200216 | -37475.38577997845 | -0.185063633481375 | 0 |  |  | B | [NAME] | 29460 | 16952 | 13814.80128522373 | 13814.80128522373 | 0
[NAME] | 29140 | 56890 | 0.03732648172485219 | 46361.72989124457 | 46361.72989124457 | -10528.27010875543 | -0.1850636334813751 | 0 |  |  | B | [NAME] | 1025 | 1994 | 1624.983114838138 | 1624.983114838138 | 0
[NAME] | 584 | 554 | 0.000363488677721359 | 451.4747470513182 | 451.4747470513182 | -102.5252529486818 | -0.1850636334813751 | 0 |  |  | B | [NAME] | 391246 | 487522 | 397299.407277893 | 397299.407277893 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  | C | KatieCantlon | 127269 | 117210 | 119117.8386641466 | 119117.8386641466 | 0
[NAME] | 317684 | 277696 | 0.182200996116445 | 226304.569236756 | 226304.569236756 | -51391.43076324396 | -0.1850636334813752 | 0 |  |  | C | [NAME] | 133374 | 58554 | 59507.089200072 | 59507.089200072 | 0
[NAME] | 433506 | 448704 | 0.2944022087514164 | 365665.207402373 | 365665.207402373 | -83038.79259762698 | -0.1850636334813752 | 0 |  |  | C | [NAME] | 253308 | 242980 | 246935.0092877258 | 246935.0092877258 | 0
[NAME] | 29460 | 16952 | 0.01112249109157487 | 13814.80128522373 | 13814.80128522373 | -3137.19871477627 | -0.1850636334813751 | 0 |  |  | C | [NAME] | 58730 | 34670 | 35234.32698989815 | 35234.32698989815 | 0
[NAME] | 1025 | 1994 | 0.001308296793098177 | 1624.983114838138 | 1624.983114838138 | -369.0168851618619 | -0.1850636334813751 | 0 |  |  | C | [NAME] | 49300 | 41614 | 42291.35515885842 | 42291.35515885842 | 0
[NAME] | 391246 | 487522 | 0.3198713486282895 | 397299.407277893 | 397299.407277893 | -90222.59272210696 | -0.1850636334813751 | 0 |  |  | C | [NAME] | 181256 | 43916 | 44630.82503860303 | 44630.82503860303 | 0
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 335760.36 | 186050 | 189078.3540949106 | 189078.3540949106 | 0
 | 1381798 | 1524119 | 1 | 1242060.000002 | 1242060.000002 | -139737.999998 | -0.1011276612051834 | 0 |  |  | C | [NAME] | 78376 | 65688 | 66757.21001766455 | 66757.21001766455 | 0
 |  |  |  |  |  |  |  |  |  |  | C | [NAME]
Product C |  |  |  |  |  |  |  |  |  |  | C | [NAME]
TM Name | 2011 | 2012 | 2012 % Contribution | 2013 Model Quota | [NAME] | $ Growth | % Growth | SDM Adjust |  |  | C | [NAME] | 12012 | 22568 | 22935.34154912089 | 22935.34154912089 | 0
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
Product | (All)
 | Values
TM Name | 2011 | 2012 | 2013 Model Quota | [NAME] | % Of 2012 | Sum of $ Growth
[NAME] | 893484 | 1012414 | 997253.3381126293 | 997253.3381126293 | 0.1465995287565103 | 118930
[NAME] | 40464 | 66728 | 70268.17866291877 | 70268.17866291877 | 0.00966234500398495 | 26264
[NAME] | 430781 | 548813 | 617259.0168954434 | 617259.0168954434 | 0.07946919656923619 | 118032
[NAME] | 1081166 | 1260688 | 1271524.369385981 | 1271524.369385981 | 0.1825500898930551 | 179522
[NAME] | 497566 | 537930 | 595912.6389513303 | 595912.6389513303 | 0.07789331686838545 | 40364
KatieCantlon | 513611 | 509846 | 561709.8441598321 | 561709.8441598321 | 0.07382669870072099 | -3765
[NAME] | 949804.36 | 962410 | 980941.9673824324 | 980941.9673824324 | 0.1393588516857265 | 12605.64000000001
[NAME] | 722837 | 931328 | 962983.4199598202 | 962983.4199598202 | 0.1348581172501992 | 208491
[NAME] | 367078.8 | 340335 | 363743.8581736548 | 363743.8581736548 | 0.0492811741237744 | -26743.79999999999
[NAME] | 407479 | 602984 | 678791.4735785517 | 678791.4735785517 | 0.08731326339591867 | 195505
[NAME] | 166413 | 132508 | 149647.2447484063 | 149647.2447484063 | 0.01918741775248828 | -33905
Grand Total | 6070684.16 | 6905984 | 7250035.350011 | 7250035.350011 | 1 | 835299.8399999999