Spreadsheet: 200753d1355754983-a-better-pivot-table-a-better-pivot-table_jpr73
Sheet: Sheet1

Product A
TM Name | 2011 | 2012 | 2012 % Contribution | 2013 Model Quota | [NAME] | $ Growth | % Growth | SDM Adjust
[NAME] | 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
[NAME] | 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
[NAME] | 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 | (Tous)
[NAME] | Colonne
TM Name | 2011 | 2012 | 2012 % Contribution | 2013 Model Quota | [NAME] | $ Growth | % Growth | SDM Adjust
[NAME] | 513611 | 509846 | 0.2337869751940889 | 561709.8441598321 | 561709.8441598321 | 51863.84415983206 | -0.03463800243516102 | 0
[NAME] | 497566 | 537930 | 0.1868969702401809 | 595912.6389513303 | 595912.6389513303 | 57982.63895133039 | -0.03463800243516102 | 0
[NAME] | 722837 | 931328 | 0.5379848570526649 | 962983.4199598202 | 962983.4199598202 | 31655.41995982022 | -0.03463800243516058 | 0
[NAME] | 367078.8 | 340335 | 0.1344109442760337 | 363743.8581736548 | 363743.8581736548 | 23408.85817365481 | -0.03463800243516091 | 0
[NAME] | 407479 | 602984 | 0.1742875368861362 | 678791.4735785517 | 678791.4735785517 | 75807.47357855158 | -0.03463800243516091 | 0
[NAME] | 430781 | 548813 | 0.1645148516262781 | 617259.0168954434 | 617259.0168954434 | 68446.01689544343 | 0.1504256310462144 | 0
[NAME] | 949804.36 | 962410 | 0.5201243643880507 | 980941.9673824324 | 980941.9673824324 | 18531.96738243246 | -0.0346380024351608 | 0
[NAME] | 893484 | 1012414 | 0.484183823400715 | 997253.3381126293 | 997253.3381126293 | -15160.66188737085 | -0.0346380024351608 | 0
[NAME] | 40464 | 66728 | 0.02201769675018257 | 70268.17866291877 | 70268.17866291877 | 3540.178662918763 | -0.05091510049971659 | 0
[NAME] | 166413 | 132508 | 0.02987581670887134 | 149647.2447484063 | 149647.2447484063 | 17139.24474840632 | -0.05091510049971659 | 0
[NAME] | 1081166 | 1260688 | 0.5119161634767978 | 1271524.369385981 | 1271524.369385981 | 10836.36938598094 | -0.03463800243516091 | 0
Total général | 6070684.16 | 6905984 | 2.999999999999999 | 7250035.350011 | 7250035.350011 | 344051.3500110001 | -0.2285085894345057 | 0