数据分析实例5-2按照年度销售额确定产品的排名榜

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455ABC类别名称(全部)求和项:销售额订购日期产品名称94年度95年度C魌edeBlaye62807.8599378588.87497Th黵ingerRostbratwurst23326.2399857042.432RacletteCourdavault25604.6999545550.99996CamembertPierrot16890.8599729934.61999Tarteausucre18485.67528749.29496ManjimupDriedApples15306.3999626513.24999GnocchidinonnaAlice19563.1599823029.89998CarnarvonTigers8587.49998220584.37498AliceMutton13810.9799919055.39999UncleBob'sOrganicDriedPears3211.7999918832.5Ikura3832.83999517034.49997Gudbrandsdalsost6791.75999615150.59998WimmersguteSemmelkn鰀el7853.64999514104.31749R鰏sleSauerkraut12173.9599913522.67999IpohCoffee10826.0999912700.59998MozzarelladiGiovanni12650.5299912249.59999Fl鴗emysost7329.34999612221.67499SirRodney'sMarmalade10797.311766.05999Gumb鋜Gummib鋜chen8383.04999211466.09447BostonCrabMeat6524.70999411385.91999Chang5681.75998710674.19999Lakkalik鲻ri5250.23999310510.19998PerthPasties10235.6099910338.55999QuesoManchegoLaPastora2199.05999310058.59999Siropd'閞able4559.9999869792.599978Pavlova7459.654989756.120491Chai3189.5999929598.499988Vegie-spread6814.8149829008.279997P鈚?chinois8885.9999878540.399983InlagdSill5392.9599978065.499994Nord-OstMatjeshering5456.5499967967.647498Chartreuseverte4508.6399927785.899993NorthwoodsCranberrySauce5219.9999987551.999992OutbackLager3341.3999987355.24999LouisianaFieryHotPepperSauce6571.8549947298.034991SteeleyeStout6415.1999887228.799995QuesoCabrales5824.769996908.999998SchoggiSchokolade8295.3756804.5GorgonzolaTelino8258.3749856662.499994SirRodney'sScones2521.9999966581.999995OriginalFrankfurtergr黱eSo遝2650.1799986500.649996Grandma'sBoysenberrySpread7206416.999999Gustaf'sKn鋍kebr鰀801.35999996321Jack'sNewEnglandClamChowder2517.3724976162.972498SingaporeanHokkienFriedMee2609.5999975965.399991ScottishLongbreads3023.9999995689.999998Rh鰊br鋟Klosterbier2934.6149985242.874995Maxilaku4145.5999985098.999996MascarponeFabioli3388.1599885015.999998RavioliAngelo2845.0499994816.5565758596061626364656667686970717273747576777879808182ABCMishiKobeNiku2715.9999884510.5Konbu603.83999984356.599992EscargotsdeBourgogne1642.9999964238.674994Spegesild1737.7199984145.279997SasquatchAle2218.9999994131.399994GulaMalacca5790.5999944125.344997TeatimeChocolateBiscuits2195.0399983667.579998ChefAnton'sCajunSeasoning5046.799993521.099998ChefAnton'sGumboMix1931.1999963416Valkoinensuklaa1215.53100.187499R鴊edesild1303.3999943034.774995Guaran?Fant醩tica1553.4899982950.874998R鰀Kaviar1229.9999992767.199996Zaansekoeken1200.2299992757.85Tofu5552.0999962439.389998Tourti鑢e2341.6299992386.607496Tunnbr鰀2225.6999962375.999998FiloMix11762056.949998NuNuCaNu?Nougat-Creme1775.1999991929.199997LaughingLumberjackLager5601836.799996AniseedSyrup13841660Gravadlax1232.3999991455.999995GenenShouyu641.69999991143.125LouisianaHotSpicedOkra2447.999995935LonglifeTofu1519.999999912.5Geitost921.9999994726.1249998Chocolade907.1624944461.549999312345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455ABCDEFGHIJ产品名称94年度95年度94年度名次95年度名次名次升降C魌edeBlaye62807.978588.911000Th黵ingerRostbratwurst23326.257042.43212020RacletteCourdavault25604.745551.023-1CamembertPierrot16890.929934.6642Tarteausucre18485.728749.3550ManjimupDriedApples15306.426513.2761GnocchidinonnaAlice19563.223029.947-3CarnarvonTigers8587.520584.41587AliceMutton13811.019055.489-1UncleBob'sOrganicDriedPears3211.818832.5421032Ikura3832.817034.5391128Gudbrandsdalsost6791.815150.6231211WimmersguteSemmelkn鰀el7853.614104.319136R鰏sleSauerkraut12174.013522.71014-4IpohCoffee10826.112700.61115-4MozzarelladiGiovanni12650.512249.6916-7Fl鴗emysost7329.312221.721174SirRodney'sMarmalade10797.311766.11218-6Gumb鋜Gummib鋜chen8383.011466.11619-3BostonCrabMeat6524.711385.925205Chang5681.810674.229218Lakkalik鲻ri5250.210510.2332211PerthPasties10235.610338.61323-10QuesoManchegoLaPastora2199.110058.6562432Siropd'閞able4560.09792.6362511Pavlova7459.79756.12026-6Chai3189.69598.5432716Vegie-spread6814.89008.32228-6P鈚?chinois8886.08540.41429-15InlagdSill5393.08065.532302Nord-OstMatjeshering5456.57967.631310Chartreuseverte4508.67785.937325NorthwoodsCranberrySauce5220.07552.034331OutbackLager3341.47355.241347LouisianaFieryHotPepperSauce6571.97298.02435-11SteeleyeStout6415.27228.82636-10QuesoCabrales5824.86909.02737-10SchoggiSchokolade8295.46804.51738-21GorgonzolaTelino8258.46662.51839-21SirRodney'sScones2522.06582.0504010OriginalFrankfurtergr黱eSo遝2650.26500.648417Grandma'sBoysenberrySpread720.06417.0744232Gustaf'sKn鋍kebr鰀801.46321.0734330Jack'sNewEnglandClamChowder2517.46163.051447SingaporeanHokkienFriedMee2609.65965.449454ScottishLongbreads3024.05690.04446-2Rh鰊br鋟Klosterbier2934.65242.94547-2Maxilaku4145.65099.03848-10MascarponeFabioli3388.25016.04049-9RavioliAngelo2845.04816.54650-4MishiKobeNiku2716.04510.54751-4Konbu603.84356.6765224EscargotsdeBourgogne1643.04238.761538565758596061626364656667686970717273747576777879ABCDEFGHIJSpegesild1737.74145.360546SasquatchAle2219.04131.455550GulaMalacca5790.64125.32856-28TeatimeCh