《案例 創(chuàng)建數(shù)據(jù)透視表》由會(huì)員分享，可在線閱讀，更多相關(guān)《案例 創(chuàng)建數(shù)據(jù)透視表（9頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。
1、地區(qū)省份城市性質(zhì)店名本月指標(biāo)實(shí)際銷售金額銷售成本東北遼寧大連自營(yíng)AAAA-00115000057062.0020972.25東北遼寧大連自營(yíng)AAAA-002280000130192.5046208.17東北遼寧大連自營(yíng)AAAA-00319000086772.0031355.81東北遼寧沈陽(yáng)自營(yíng)AAAA-00490000103890.0039519.21東北遼寧沈陽(yáng)自營(yíng)AAAA-005270000107766.0038357.70東北遼寧沈陽(yáng)自營(yíng)AAAA-00618000057502.0020867.31東北遼寧沈陽(yáng)自營(yíng)AAAA-007280000116300.0040945.10東北遼寧沈陽(yáng)自
2、營(yíng)AAAA-00834000063287.0022490.31東北遼寧沈陽(yáng)自營(yíng)AAAA-009150000112345.0039869.15東北遼寧沈陽(yáng)自營(yíng)AAAA-01022000080036.0028736.46東北遼寧沈陽(yáng)自營(yíng)AAAA-01112000073686.5023879.99東北黑龍江齊齊哈爾加盟AAAA-01235000047394.5017636.83華北北京北京加盟AAAA-01326000057255.6019604.20華北天津天津加盟AAAA-01432000051085.5017406.07華北北京北京自營(yíng)AAAA-01520000059378.0021060.8
3、4華北北京北京自營(yíng)AAAA-01610000048519.0018181.81華北北京北京自營(yíng)AAAA-017330000249321.5088623.41華北北京北京自營(yíng)AAAA-01825000099811.0036295.97華北北京北京自營(yíng)AAAA-01917000087414.0033288.20華北北京北京自營(yíng)AAAA-020160000104198.0037273.60華北北京北京自營(yíng)AAAA-021150000130105.0045015.67華北北京北京自營(yíng)AAAA-02240000071124.0025083.74華北北京北京自營(yíng)AAAA-02326000097924.00
4、34108.31華北北京北京自營(yíng)AAAA-02430000072650.5024486.13華北北京北京自營(yíng)AAAA-02511000075632.0026902.86華北天津天津自營(yíng)AAAA-02634000082089.0029116.92華北山東濟(jì)南自營(yíng)AAAA-02728000072584.0028174.69華北山東煙臺(tái)自營(yíng)AAAA-02813000032033.0012905.52華北山東濟(jì)南自營(yíng)AAAA-02932000049939.0019900.90華北山東濟(jì)南自營(yíng)AAAA-03024000075841.0029013.92華北山東青島自營(yíng)AAAA-0313300008486
5、2.0032672.02華北河北秦皇島加盟AAAA-03224000087255.5030595.70華北河北石家莊加盟AAAA-03325000084674.5030153.72華北河北唐山加盟AAAA-03414000091084.0033431.44華北山西山西加盟AAAA-035210000100483.5034143.90華北山西山西加盟AAAA-0369000031398.0012056.14華北山西山西加盟AAAA-0379000027749.009988.23華北山東濟(jì)南加盟AAAA-03816000097840.5036131.02華北山東濟(jì)南加盟AAAA-039110000
6、78690.0028750.52華北山東濰坊加盟AAAA-04031000054940.5019929.52華北山東濰坊加盟AAAA-04120000026127.508951.88華北山東淄博加盟AAAA-04237000034785.5012430.58華北河南河南加盟AAAA-04315000039418.0014499.12華北河南河南加盟AAAA-0448000055732.0021030.08華北河南開(kāi)封加盟AAAA-04521000055254.0020277.18華北河北滄州加盟AAAA-04619000019707.006777.39華東福建福州自營(yíng)AAAA-04738000
7、0143488.0054508.71華東福建福州自營(yíng)AAAA-048390000133238.5050618.49華東福建福州自營(yíng)AAAA-049350000144797.0055811.66華東福建福州自營(yíng)AAAA-05031000059182.0022488.11華東福建泉州自營(yíng)AAAA-0518000033127.5012726.31華東福建泉州自營(yíng)AAAA-05223000047428.0018171.07華東福建廈門自營(yíng)AAAA-053140000115307.5045074.62華東福建廈門自營(yíng)AAAA-054350000106703.0042049.74華東福建廈門自營(yíng)AAAA-
8、05533000098162.5039030.18華東福建廈門自營(yíng)AAAA-05680000108026.0041915.66華東福建廈門自營(yíng)AAAA-057170000127802.0050370.11華東江蘇南京自營(yíng)AAAA-05830000097473.0039293.32華東江蘇南京自營(yíng)AAAA-059260000225713.0087514.96華東江蘇蘇州自營(yíng)AAAA-0608000087781.0032578.92華東江蘇太倉(cāng)自營(yíng)AAAA-06140000027738.0010091.54華東江蘇蕪湖自營(yíng)AAAA-06223000061861.0022089.60華東江蘇宜興自營(yíng)
9、AAAA-06326000052791.0020683.86華東江蘇常州自營(yíng)AAAA-064390000119017.0049072.13華東江蘇鎮(zhèn)江自營(yíng)AAAA-06527000073155.0028003.74華東江蘇常熟自營(yíng)AAAA-06615000048007.0019209.82華東江蘇常熟自營(yíng)AAAA-0678000027312.0010499.07華東江蘇常州自營(yíng)AAAA-06838000083735.8032020.30華東江蘇昆山自營(yíng)AAAA-06940000039792.2016006.37華東江蘇南京自營(yíng)AAAA-070280000150337.2056259.38華東江
10、蘇南京自營(yíng)AAAA-07125000049262.0019088.07華東江蘇南京自營(yíng)AAAA-07223000080842.0030566.43華東江蘇南京自營(yíng)AAAA-07314000052031.0019665.57華東江蘇蘇州自營(yíng)AAAA-07420000068165.0031946.86華東江蘇蘇州自營(yíng)AAAA-07524000057826.0020432.87華東江蘇無(wú)錫自營(yíng)AAAA-076380000169513.5064451.36華東江蘇無(wú)錫自營(yíng)AAAA-07726000046243.2018718.74華東江蘇無(wú)錫自營(yíng)AAAA-07835000060735.0021733.
11、05華東江蘇吳江自營(yíng)AAAA-07928000036938.0014144.45華東江蘇無(wú)錫自營(yíng)AAAA-08033000069088.0022770.55華東上海上海自營(yíng)AAAA-081210000144717.0053529.84華東上海上海自營(yíng)AAAA-082370000143178.0053815.57華東上海上海自營(yíng)AAAA-08311000064120.0027220.60華東上海上海自營(yíng)AAAA-08413000072720.0027514.13華東上海上海郊縣自營(yíng)AAAA-085270000134295.0051111.86華東上海上海自營(yíng)AAAA-08626000015423
12、0.0057516.18華東上海上海自營(yíng)AAAA-087210000185887.0067459.56華東上海上海自營(yíng)AAAA-095120000147275.2055259.29華東上海上海自營(yíng)AAAA-096100000161420.0060302.85華東上海上海自營(yíng)AAAA-09716000088067.0032786.34華東上海上海自營(yíng)AAAA-098340000153762.0058099.51華東上海上海自營(yíng)AAAA-09932000091776.5035378.17華東上海上海自營(yíng)AAAA-10028000044582.0017198.84華東上海上海自營(yíng)AAAA-10135
13、0000196922.0075073.81華東上海上海自營(yíng)AAAA-102260000132376.0049560.62華東上海上海自營(yíng)AAAA-103230000267968.00101538.92華東上海上海自營(yíng)AAAA-10433000089749.0037454.80華東上海上海自營(yíng)AAAA-105380000184037.0070037.31華東上海上海自營(yíng)AAAA-10690000138033.0053140.45華東上海上海自營(yíng)AAAA-107110000107421.0040346.81華東上海上海自營(yíng)AAAA-108170000102873.0036460.34華東上海上海自
14、營(yíng)AAAA-109230000279503.5438299.40華東上海上海自營(yíng)AAAA-11013000026201.8011673.15華東上海上海自營(yíng)AAAA-11190000337151.60126775.82華東上海上海郊縣自營(yíng)AAAA-11227000077594.0031178.43華東上海上海郊縣自營(yíng)AAAA-11327000088040.0035938.89華東上海上海郊縣自營(yíng)AAAA-114210000176789.6067626.74華東上海上海郊縣自營(yíng)AAAA-11519000089907.0033495.39華東上海上海郊縣自營(yíng)AAAA-11638000086219.
15、0034388.27華東上海上海郊縣自營(yíng)AAAA-11740000072110.0027751.11華東上海上海郊縣自營(yíng)AAAA-11831000075627.0029372.07華東上海上海自營(yíng)AAAA-11927000044867.0013393.43華東上海上海自營(yíng)AAAA-1209000034733.2010761.82華東浙江富陽(yáng)自營(yíng)AAAA-12115000044269.0016708.48華東浙江杭州自營(yíng)AAAA-12213000053034.0020393.67華東浙江杭州自營(yíng)AAAA-12380000120190.0045913.90華東浙江杭州自營(yíng)AAAA-12419000
16、081298.4031574.59華東浙江杭州自營(yíng)AAAA-12519000092160.8035284.06華東浙江寧波自營(yíng)AAAA-126190000104677.3039713.93華東浙江寧波自營(yíng)AAAA-12717000049917.2019047.13華東浙江溫州自營(yíng)AAAA-12827000070575.0026597.65華東安徽蚌埠加盟AAAA-12910000059202.0020915.93華東安徽阜陽(yáng)加盟AAAA-13027000046661.0017428.09華東安徽合肥加盟AAAA-13190000101737.0036708.13華東安徽合肥加盟AAAA-132
17、30000060415.5022461.99華東福建福建加盟AAAA-13333000031012.0011155.84華東福建福建加盟AAAA-13421000059495.5021511.63華東福建福建加盟AAAA-13510000051182.5018011.23華東福建泉州加盟AAAA-13616000066526.0024139.33華東江蘇東臺(tái)加盟AAAA-13739000030857.0011341.85華東江蘇淮安加盟AAAA-13838000076487.0026350.97華東江蘇江陰加盟AAAA-13923000092477.0031745.84華東江蘇連云港加盟AAA
18、A-1407000063523.0022896.33華東江蘇南通加盟AAAA-14123000068748.5024883.33華東江蘇秦州加盟AAAA-14224000067939.0024401.79華東江蘇通州加盟AAAA-14326000041735.0014033.92華東江蘇無(wú)錫加盟AAAA-14438000085948.0031323.68華東江蘇無(wú)錫加盟AAAA-14519000079895.0028975.01華東江蘇丹陽(yáng)加盟AAAA-14630000054622.0019434.14華東浙江浙江加盟AAAA-14740000041125.0015340.69華東浙江浙江加盟
19、AAAA-14811000025843.009296.13華東浙江浙江加盟AAAA-14938000043769.5015671.04華東浙江浙江加盟AAAA-15029000047785.0017446.09華東浙江浙江加盟AAAA-15119000054112.0018325.69華東浙江浙江加盟AAAA-15218000056516.5020681.82華東浙江浙江加盟AAAA-15325000041391.0015302.06華東浙江浙江加盟AAAA-15427000013902.204851.37華東浙江浙江加盟AAAA-15533000047192.0017161.16華東江蘇揚(yáng)州
20、加盟AAAA-15638000060476.5022306.30華東福建福州自營(yíng)AAAA-15710000041917.0014076.55華南廣東廣州自營(yíng)AAAA-15812000052785.1021237.42華南廣東廣州自營(yíng)AAAA-15923000083692.0033788.84華南廣東廣州自營(yíng)AAAA-16025000042910.4018086.36華南廣東深圳自營(yíng)AAAA-16111000055218.5023788.94華南廣東深圳自營(yíng)AAAA-16215000095128.0035791.34華南廣東深圳自營(yíng)AAAA-16332000084445.0030587.81華南
21、廣東深圳自營(yíng)AAAA-16435000071967.0027414.23華南廣東深圳自營(yíng)AAAA-16521000046948.5017717.88華南廣東深圳自營(yíng)AAAA-1668000078171.0029210.03華南廣東深圳自營(yíng)AAAA-1679000044010.5017014.54華南廣東東莞加盟AAAA-16817000073297.5027968.43華南廣東東莞加盟AAAA-16915000086530.0030961.41華南廣東汕頭加盟AAAA-170350000102682.0035668.55華南廣東深圳加盟AAAA-17133000049888.0016644.1
22、4華南廣東東莞加盟AAAA-17210000043431.0011006.04華南海南海口加盟AAAA-17333000091160.0032220.27華南海南?？诩用薃AAA-1749000081095.5027293.96華南廣東佛山加盟AAAA-17516000078751.5050038.23華中江西南昌自營(yíng)AAAA-17625000034068.0011887.77華中湖北武漢自營(yíng)AAAA-17739000053487.0020005.77華中湖北宜昌自營(yíng)AAAA-17815000049880.0017679.11華中湖北武漢自營(yíng)AAAA-18316000042190.001565
23、6.44華中湖北武漢自營(yíng)AAAA-18433000053083.0019358.41華中湖北武漢自營(yíng)AAAA-185260000103156.0037469.31華中湖南長(zhǎng)沙加盟AAAA-186360000120957.5042528.11華中湖南長(zhǎng)沙加盟AAAA-18738000074768.0027787.34西北陜西西安自營(yíng)AAAA-188380000119815.5039582.96西北陜西西安自營(yíng)AAAA-189310000271057.7090307.67西北陜西西安自營(yíng)AAAA-19418000077982.1026099.07西北內(nèi)蒙古包頭加盟AAAA-195340000725
24、53.5026539.65西北內(nèi)蒙古呼和浩特加盟AAAA-19633000073663.5026525.95西北內(nèi)蒙古呼和浩特加盟AAAA-19720000042953.5015441.06西北陜西寶雞加盟AAAA-19825000053222.5019271.22西北陜西延安加盟AAAA-19939000081474.5028245.85西北甘肅蘭州加盟AAAA-20040000050978.0018331.70西北陜西西安自營(yíng)AAAA-20132000045495.0015222.54西南四川成都自營(yíng)AAAA-205110000102173.0037869.18西南四川成都自營(yíng)AAAA-2
25、06200000103908.0040502.56西南四川成都自營(yíng)AAAA-207100000116719.2045129.10西南四川成都自營(yíng)AAAA-20837000033480.509013.31西南四川成都自營(yíng)AAAA-209270000125187.0045645.87西南重慶重慶自營(yíng)AAAA-21012000062012.0022574.10西南重慶重慶自營(yíng)AAAA-21219000022594.109914.22西南重慶重慶自營(yíng)AAAA-213330000108316.0038732.25西南重慶重慶自營(yíng)AAAA-21414000085770.5031126.64西南重慶重慶自營(yíng)
26、AAAA-21514000015499.004637.82西南貴州貴陽(yáng)加盟AAAA-21615000060446.0019841.12西南云南昆明加盟AAAA-217100000108658.0032389.82西南重慶重慶自營(yíng)AAAA-21817000064530.0023309.43性性質(zhì)數(shù)數(shù)據(jù)據(jù)加加盟盟自自營(yíng)地地區(qū)區(qū)省省份份銷售售額成成本本利利潤(rùn)銷售售額華北北北京57255.619604.237651.41096077河北282721100958.25181762.75河南15040455806.3894597.62山東292384106193.52186190.48315259山西15
27、9630.556188.27103442.23天津82089華北北匯總942395.1338750.62603644.481493425東北北黑龍江47394.517636.8329757.67遼寧988839天津51085.517406.0733679.43東北北匯總9848035042.963437.1988839華東安徽268015.597514.14170501.36福建20821674818.03133397.971159179江蘇722708257693.16465014.841785356.9上海5047512.04浙江371636.2134076.05237560.156161
28、21.7華東匯總1570575.7564101.381006474.328608169.64華南南廣東434580172286.8262293.2655276海南172255.559514.23112741.27華南南匯總606835.5231801.03375034.47655276華中中湖北687557.2湖南195725.570315.45125410.05江西34068華中中匯總195725.570315.45125410.05721625.2西西北北甘肅5097818331.732646.3內(nèi)蒙古189170.568506.66120663.84陜西13469747517.07871
29、79.93885276.5西西北北匯總374845.5134355.43240490.07885276.5西西南南貴州6044619841.1240604.88四川1114771.93云南10865832389.8276268.18重慶420755.1西西南南 匯總16910452230.94116873.061535527.03成成本本利利潤(rùn)390320.54705756.46122667.05192591.9529116.9252972.08542104.51951320.49353201.46635637.54353201.46635637.54446841.21712337.79686
30、840.961098515.941849298.053198213.99235233.41380888.293218213.635389956.01254637.39400638.61254637.39400638.61252066.98435490.2211887.7722180.23263954.75457670.45297419.08587857.42297419.08587857.42296201.01818570.92153423.61267331.49449624.621085902.41自自營(yíng)數(shù)據(jù)性質(zhì)地區(qū)門店數(shù)最低銷售額最高銷售額平均銷售額銷售總額自營(yíng)東北115706213019
31、2.589894988839華北1732033249321.5878491493425華東8326201.8337151.61037138608169.64華南1042910.49512865528655276華中103406815582372163721625.2西北835594271057.7110660885276.5西南1515499406985.231023681535527.03自營(yíng) 匯總15415499406985.239667614888138.37加盟東北247394.551085.54924098480華北1619707100483.558900942395.1華東2813
32、902.2101737560921570575.7華南84343110268275854606835.5華中274768120957.597863195725.5西北642953.581474.562474374845.5西南26044610865884552169104加盟 匯總6413902.2120957.5618433957961.3總計(jì)21813902.2406985.238645018846099.67數(shù)據(jù)地區(qū)銷售總額份額東北10873195.77%華北2435820.112.92%華東10178745.3454.01%華南1262111.56.70%華中917350.74.87%
33、西北12601226.69%西南1704631.039.05%總計(jì)18846099.67100.00%數(shù)據(jù)地區(qū)性質(zhì)銷售額成本利潤(rùn) 完成率 毛利率東北自營(yíng)988839353201.46635637.5443.56%64.28%加盟9848035042.963437.114.70%64.42%華北自營(yíng)1493425542104.51951320.4936.69%63.70%加盟942395.1338750.62603644.4830.80%64.05%華東自營(yíng)8608169.643218213.635389956.0144.14%62.61%加盟1570575.7564101.381006474.
34、3222.40%64.08%華南自營(yíng)655276254637.39400638.6134.31%61.14%加盟606835.5231801.03375034.4736.12%61.80%華中自營(yíng)721625.2263954.75457670.4529.57%63.42%加盟195725.570315.45125410.0526.45%64.07%西北自營(yíng)885276.5297419.08587857.4234.31%66.40%加盟374845.5134355.43240490.0719.63%64.16%西南自營(yíng)1535527.03449624.621085902.4148.29%70.72%加盟16910452230.94116873.0667.64%69.11%
案例 創(chuàng)建數(shù)據(jù)透視表
