Spreadsheet: 749950d1633110277-array-formula-calc-for-top-top-bottom-example
Sheet: Top-Bottom %

Location(example) | Product | UPC | Average Price | APSD Units | APSD $ | Rank Units | Rank $ | Units | Dollars | % of $ | Accum | Assortment Action | CORE FLAG | 0.8
12345 | a | 1820025001 | 2.171344815936019 | 23.3580290537888 | 50.7183352964272 | 1 | 1 | 1189858 | 2583592
12345 | b | 1820025002 | 1.57002723383059 | 18.4881631631632 | 29.0269196696697 | 2 | 2 | 738787 | 1159915.71
12345 | c | 1820025010 | 2.642070970642039 | 8.22465401344405 | 21.7301196124951 | 4 | 3 | 416003 | 1099109.45
12345 | d | 1820025003 | 1.633889160568534 | 12.9967992684042 | 21.2353294467307 | 3 | 4 | 568480 | 928833.31
12345 | e | 1820025000 | 2.223906825514393 | 7.83254670599803 | 17.4188540806293 | 5 | 5 | 398285 | 885748.73
12345 | f | 3410000355 | 2.167856768682748 | 6.42749059219647 | 13.9338789859378 | 6 | 6 | 324524 | 703521.55
12345 | g | 8066095721 | 2.652884574573183 | 2.76062626262626 | 7.32362282828283 | 7 | 7 | 136651 | 362519.33
12345 | h | 1820025508 | 2.878201561552456 | 2.09023569023569 | 6.01611962764904 | 8 | 8 | 105536 | 303753.88
12345 | i | 8769283231 | 2.772166682604953 | 2.38091985428051 | 6.60030669398907 | 9 | 9 | 104570 | 289885.47
12345 | j | 7231132124 | 2.993301274549439 | 1.87500498703371 | 5.61245481747457 | 11 | 10 | 93994 | 281352.36
12345 | k | 3354495060 | 2.975642647519731 | 1.49987179487179 | 4.46308247863248 | 13 | 11 | 70194 | 208872.26
12345 | l | 7199030065 | 2.303640275387263 | 1.90532901833873 | 4.38919266450917 | 12 | 12 | 88312 | 203439.08
12345 | m | 8066095796 | 2.990100042186465 | 1.35067155067155 | 4.03864306064306 | 15 | 13 | 66372 | 198458.92
12345 | n | 8982613028 | 2.849724322858606 | 1.48405991504583 | 4.22916163648558 | 14 | 14 | 66382 | 189170.4
12345 | o | 8769275231 | 2.826181778428108 | 1.80995433789954 | 5.1152599695586 | 18 | 15 | 59457 | 168036.29
12345 | p | 1820025509 | 2.835125339556252 | 1.24633037945921 | 3.53350284026358 | 20 | 16 | 54851 | 155509.46
12345 | q | 1820025510 | 2.906471142077017 | 1.22672672672673 | 3.56544583044583 | 21 | 17 | 53105 | 154348.15
23456 | r | 1820025004 | 1.545974705446156 | 3.77218337218337 | 5.83170007770008 | 10 | 18 | 97096 | 150107.96
23456 | s | 8982630040 | 3.032617814789186 | 1.01893994651106 | 3.09005543398979 | 29 | 19 | 41909 | 127093.98
23456 | t | 1820025527 | 2.89769075866754 | 0.976474769012082 | 2.82952191423833 | 30 | 20 | 41217 | 119434.12
23456 | u | 1820026110 | 3.002135547899419 | 0.892883379247016 | 2.68055693296602 | 32 | 21 | 38894 | 116765.06
23456 | v | 3354400026 | 3.011274557823129 | 0.903392330383481 | 2.72036234021632 | 34 | 22 | 36750 | 110664.34
23456 | w | 63598525875 | 1.873053796662536 | 1.58864617044229 | 2.97561974110032 | 19 | 23 | 58907 | 110335.98
23456 | x | 63598526038 | 2.58875799840032 | 0.935859649122807 | 2.42271415204678 | 31 | 24 | 40008 | 103571.03
23456 | y | 3410000008 | 2.050684490452999 | 2.08910174542358 | 4.28408854831843 | 24 | 25 | 49073 | 100633.24
23456 | z | 7199048024 | 1.565502448857462 | 2.50193065405831 | 3.91677856579984 | 16 | 26 | 63499 | 99407.84
23456 | zz | 1820025005 | 2.0200471374878 | 2.57248931623932 | 5.19654967948718 | 25 | 27 | 48157 | 97279.41
23456 | aa | 8200072569 | 3.023323971790551 | 0.89463986599665 | 2.70478615298716 | 39 | 28 | 32046 | 96885.44
23456 | vv | 1820025940 | 2.709225328393398 | 0.821300138312586 | 2.22508713692946 | 36 | 29 | 35628 | 96524.28
23456 | bb | 1820000115S | 1.479115962022235 | 3.21413667188315 | 4.75408085550339 | 17 | 30 | 61615 | 91135.73
23456 | nn | 8066095683 | 3.792236765074852 | 0.922608024691358 | 3.49874807098765 | 47 | 31 | 23914 | 90687.55
23456 | [NAME] | 63598526039 | 2.570959379175076 | 0.822900584795322 | 2.11564397660819 | 37 | 32 | 35179 | 90443.78
23456 | dd | 8982690124 | 2.086168103245254 | 1.51217948717949 | 3.15466061253561 | 28 | 33 | 42462 | 88582.87
23456 | ff | 8982613040 | 2.864051548062895 | 0.680004409171076 | 1.94756768077601 | 41 | 34 | 30845 | 88341.67
23456 | gg | 8857333024 | 2.268975346485368 | 1.16191780821918 | 2.63636286149163 | 33 | 35 | 38169 | 86604.52
23456 | ff | 1820025007 | 1.591146932163881 | 2.08320987654321 | 3.31469300411523 | 22 | 36 | 50622 | 80547.04
23456 | hh | 1820025008 | 1.594247848537005 | 2.33498817966903 | 3.72254988179669 | 23 | 37 | 49385 | 78731.93
23456 | jj | 1820025006 | 1.782057825066642 | 2.50091168091168 | 4.45676923076923 | 27 | 38 | 43891 | 78216.3
23456 | kk | 8769200490 | 2.831375883392226 | 1.22710027100271 | 3.47438211382114 | 42 | 39 | 27168 | 76922.82
23456 | ll | 8066095643 | 3.051578820794421 | 0.89135405501965 | 2.72003715612719 | 45 | 40 | 24949 | 76133.84