《案例 創(chuàng)建數(shù)據(jù)透視表》由會員分享，可在線閱讀，更多相關《案例 創(chuàng)建數(shù)據(jù)透視表（9頁珍藏版）》請在裝配圖網(wǎng)上搜索。

1、地區(qū)省份城市性質店名本月指標實際銷售金額銷售成本東北遼寧大連自營AAAA-00115000057062.0020972.25東北遼寧大連自營AAAA-002280000130192.5046208.17東北遼寧大連自營AAAA-00319000086772.0031355.81東北遼寧沈陽自營AAAA-00490000103890.0039519.21東北遼寧沈陽自營AAAA-005270000107766.0038357.70東北遼寧沈陽自營AAAA-00618000057502.0020867.31東北遼寧沈陽自營AAAA-007280000116300.0040945.10東北遼寧沈陽自

2、營AAAA-00834000063287.0022490.31東北遼寧沈陽自營AAAA-009150000112345.0039869.15東北遼寧沈陽自營AAAA-01022000080036.0028736.46東北遼寧沈陽自營AAAA-01112000073686.5023879.99東北黑龍江齊齊哈爾加盟AAAA-01235000047394.5017636.83華北北京北京加盟AAAA-01326000057255.6019604.20華北天津天津加盟AAAA-01432000051085.5017406.07華北北京北京自營AAAA-01520000059378.0021060.8

3、4華北北京北京自營AAAA-01610000048519.0018181.81華北北京北京自營AAAA-017330000249321.5088623.41華北北京北京自營AAAA-01825000099811.0036295.97華北北京北京自營AAAA-01917000087414.0033288.20華北北京北京自營AAAA-020160000104198.0037273.60華北北京北京自營AAAA-021150000130105.0045015.67華北北京北京自營AAAA-02240000071124.0025083.74華北北京北京自營AAAA-02326000097924.00

4、34108.31華北北京北京自營AAAA-02430000072650.5024486.13華北北京北京自營AAAA-02511000075632.0026902.86華北天津天津自營AAAA-02634000082089.0029116.92華北山東濟南自營AAAA-02728000072584.0028174.69華北山東煙臺自營AAAA-02813000032033.0012905.52華北山東濟南自營AAAA-02932000049939.0019900.90華北山東濟南自營AAAA-03024000075841.0029013.92華北山東青島自營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華北山東濟南加盟AAAA-03816000097840.5036131.02華北山東濟南加盟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華北河南開封加盟AAAA-04521000055254.0020277.18華北河北滄州加盟AAAA-04619000019707.006777.39華東福建福州自營AAAA-04738000

7、0143488.0054508.71華東福建福州自營AAAA-048390000133238.5050618.49華東福建福州自營AAAA-049350000144797.0055811.66華東福建福州自營AAAA-05031000059182.0022488.11華東福建泉州自營AAAA-0518000033127.5012726.31華東福建泉州自營AAAA-05223000047428.0018171.07華東福建廈門自營AAAA-053140000115307.5045074.62華東福建廈門自營AAAA-054350000106703.0042049.74華東福建廈門自營AAAA-

8、05533000098162.5039030.18華東福建廈門自營AAAA-05680000108026.0041915.66華東福建廈門自營AAAA-057170000127802.0050370.11華東江蘇南京自營AAAA-05830000097473.0039293.32華東江蘇南京自營AAAA-059260000225713.0087514.96華東江蘇蘇州自營AAAA-0608000087781.0032578.92華東江蘇太倉自營AAAA-06140000027738.0010091.54華東江蘇蕪湖自營AAAA-06223000061861.0022089.60華東江蘇宜興自營

9、AAAA-06326000052791.0020683.86華東江蘇常州自營AAAA-064390000119017.0049072.13華東江蘇鎮(zhèn)江自營AAAA-06527000073155.0028003.74華東江蘇常熟自營AAAA-06615000048007.0019209.82華東江蘇常熟自營AAAA-0678000027312.0010499.07華東江蘇常州自營AAAA-06838000083735.8032020.30華東江蘇昆山自營AAAA-06940000039792.2016006.37華東江蘇南京自營AAAA-070280000150337.2056259.38華東江

10、蘇南京自營AAAA-07125000049262.0019088.07華東江蘇南京自營AAAA-07223000080842.0030566.43華東江蘇南京自營AAAA-07314000052031.0019665.57華東江蘇蘇州自營AAAA-07420000068165.0031946.86華東江蘇蘇州自營AAAA-07524000057826.0020432.87華東江蘇無錫自營AAAA-076380000169513.5064451.36華東江蘇無錫自營AAAA-07726000046243.2018718.74華東江蘇無錫自營AAAA-07835000060735.0021733.

11、05華東江蘇吳江自營AAAA-07928000036938.0014144.45華東江蘇無錫自營AAAA-08033000069088.0022770.55華東上海上海自營AAAA-081210000144717.0053529.84華東上海上海自營AAAA-082370000143178.0053815.57華東上海上海自營AAAA-08311000064120.0027220.60華東上海上海自營AAAA-08413000072720.0027514.13華東上海上海郊縣自營AAAA-085270000134295.0051111.86華東上海上海自營AAAA-08626000015423

12、0.0057516.18華東上海上海自營AAAA-087210000185887.0067459.56華東上海上海自營AAAA-095120000147275.2055259.29華東上海上海自營AAAA-096100000161420.0060302.85華東上海上海自營AAAA-09716000088067.0032786.34華東上海上海自營AAAA-098340000153762.0058099.51華東上海上海自營AAAA-09932000091776.5035378.17華東上海上海自營AAAA-10028000044582.0017198.84華東上海上海自營AAAA-10135

13、0000196922.0075073.81華東上海上海自營AAAA-102260000132376.0049560.62華東上海上海自營AAAA-103230000267968.00101538.92華東上海上海自營AAAA-10433000089749.0037454.80華東上海上海自營AAAA-105380000184037.0070037.31華東上海上海自營AAAA-10690000138033.0053140.45華東上海上海自營AAAA-107110000107421.0040346.81華東上海上海自營AAAA-108170000102873.0036460.34華東上海上海自

14、營AAAA-109230000279503.5438299.40華東上海上海自營AAAA-11013000026201.8011673.15華東上海上海自營AAAA-11190000337151.60126775.82華東上海上海郊縣自營AAAA-11227000077594.0031178.43華東上海上海郊縣自營AAAA-11327000088040.0035938.89華東上海上海郊縣自營AAAA-114210000176789.6067626.74華東上海上海郊縣自營AAAA-11519000089907.0033495.39華東上海上海郊縣自營AAAA-11638000086219.

15、0034388.27華東上海上海郊縣自營AAAA-11740000072110.0027751.11華東上海上海郊縣自營AAAA-11831000075627.0029372.07華東上海上海自營AAAA-11927000044867.0013393.43華東上海上海自營AAAA-1209000034733.2010761.82華東浙江富陽自營AAAA-12115000044269.0016708.48華東浙江杭州自營AAAA-12213000053034.0020393.67華東浙江杭州自營AAAA-12380000120190.0045913.90華東浙江杭州自營AAAA-12419000

16、081298.4031574.59華東浙江杭州自營AAAA-12519000092160.8035284.06華東浙江寧波自營AAAA-126190000104677.3039713.93華東浙江寧波自營AAAA-12717000049917.2019047.13華東浙江溫州自營AAAA-12827000070575.0026597.65華東安徽蚌埠加盟AAAA-12910000059202.0020915.93華東安徽阜陽加盟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華東江蘇東臺加盟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華東江蘇無錫加盟AAAA-14438000085948.0031323.68華東江蘇無錫加盟AAAA-14519000079895.0028975.01華東江蘇丹陽加盟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華東江蘇揚州

20、加盟AAAA-15638000060476.5022306.30華東福建福州自營AAAA-15710000041917.0014076.55華南廣東廣州自營AAAA-15812000052785.1021237.42華南廣東廣州自營AAAA-15923000083692.0033788.84華南廣東廣州自營AAAA-16025000042910.4018086.36華南廣東深圳自營AAAA-16111000055218.5023788.94華南廣東深圳自營AAAA-16215000095128.0035791.34華南廣東深圳自營AAAA-16332000084445.0030587.81華南

21、廣東深圳自營AAAA-16435000071967.0027414.23華南廣東深圳自營AAAA-16521000046948.5017717.88華南廣東深圳自營AAAA-1668000078171.0029210.03華南廣東深圳自營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華南海南?？诩用薃AAA-17333000091160.0032220.27華南海南?？诩用薃AAA-1749000081095.5027293.96華南廣東佛山加盟AAAA-17516000078751.5050038.23華中江西南昌自營AAAA-17625000034068.0011887.77華中湖北武漢自營AAAA-17739000053487.0020005.77華中湖北宜昌自營AAAA-17815000049880.0017679.11華中湖北武漢自營AAAA-18316000042190.001565

23、6.44華中湖北武漢自營AAAA-18433000053083.0019358.41華中湖北武漢自營AAAA-185260000103156.0037469.31華中湖南長沙加盟AAAA-186360000120957.5042528.11華中湖南長沙加盟AAAA-18738000074768.0027787.34西北陜西西安自營AAAA-188380000119815.5039582.96西北陜西西安自營AAAA-189310000271057.7090307.67西北陜西西安自營AAAA-19418000077982.1026099.07西北內蒙古包頭加盟AAAA-195340000725

24、53.5026539.65西北內蒙古呼和浩特加盟AAAA-19633000073663.5026525.95西北內蒙古呼和浩特加盟AAAA-19720000042953.5015441.06西北陜西寶雞加盟AAAA-19825000053222.5019271.22西北陜西延安加盟AAAA-19939000081474.5028245.85西北甘肅蘭州加盟AAAA-20040000050978.0018331.70西北陜西西安自營AAAA-20132000045495.0015222.54西南四川成都自營AAAA-205110000102173.0037869.18西南四川成都自營AAAA-2

25、06200000103908.0040502.56西南四川成都自營AAAA-207100000116719.2045129.10西南四川成都自營AAAA-20837000033480.509013.31西南四川成都自營AAAA-209270000125187.0045645.87西南重慶重慶自營AAAA-21012000062012.0022574.10西南重慶重慶自營AAAA-21219000022594.109914.22西南重慶重慶自營AAAA-213330000108316.0038732.25西南重慶重慶自營AAAA-21414000085770.5031126.64西南重慶重慶自營

26、AAAA-21514000015499.004637.82西南貴州貴陽加盟AAAA-21615000060446.0019841.12西南云南昆明加盟AAAA-217100000108658.0032389.82西南重慶重慶自營AAAA-21817000064530.0023309.43性性質數(shù)數(shù)據(jù)據(jù)加加盟盟自自營地地區(qū)區(qū)省省份份銷售售額成成本本利利潤銷售售額華北北北京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內蒙古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成成本本利利潤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自自營數(shù)據(jù)性質地區(qū)門店數(shù)最低銷售額最高銷售額平均銷售額銷售總額自營東北115706213019

31、2.589894988839華北1732033249321.5878491493425華東8326201.8337151.61037138608169.64華南1042910.49512865528655276華中103406815582372163721625.2西北835594271057.7110660885276.5西南1515499406985.231023681535527.03自營 匯總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總計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%總計18846099.67100.00%數(shù)據(jù)地區(qū)性質銷售額成本利潤 完成率 毛利率東北自營988839353201.46635637.5443.56%64.28%加盟9848035042.963437.114.70%64.42%華北自營1493425542104.51951320.4936.69%63.70%加盟942395.1338750.62603644.4830.80%64.05%華東自營8608169.643218213.635389956.0144.14%62.61%加盟1570575.7564101.381006474.

34、3222.40%64.08%華南自營655276254637.39400638.6134.31%61.14%加盟606835.5231801.03375034.4736.12%61.80%華中自營721625.2263954.75457670.4529.57%63.42%加盟195725.570315.45125410.0526.45%64.07%西北自營885276.5297419.08587857.4234.31%66.40%加盟374845.5134355.43240490.0719.63%64.16%西南自營1535527.03449624.621085902.4148.29%70.72%加盟16910452230.94116873.0667.64%69.11%