案例 创建数据透视表

地区省份城市性质店名本月指标实际销售金额销售成本东北辽宁大连自营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东北辽宁沈阳自营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.84华北北京北京自营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.0034108.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-03133000084862.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-03911000078690.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-047380000143488.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-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华东江苏宜兴自营AAAA-06326000052791.0020683.86华东江苏常州自营AAAA-064390000119017.0049072.13华东江苏镇江自营AAAA-06527000073155.0028003.74华东江苏常熟自营AAAA-06615000048007.0019209.82华东江苏常熟自营AAAA-0678000027312.0010499.07华东江苏常州自营AAAA-06838000083735.8032020.30华东江苏昆山自营AAAA-06940000039792.2016006.37华东江苏南京自营AAAA-070280000150337.2056259.38华东江苏南京自营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.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-086260000154230.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-101350000196922.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华东上海上海自营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.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-12419000081298.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-13230000060415.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华东江苏连云港加盟AAAA-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华东浙江浙江加盟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华东江苏扬州加盟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华南广东深圳自营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.14华南广东东莞加盟AAAA-17210000043431.0011006.04华南海南海口加盟AAAA-17333000091160.0032220.27华南海南海口加盟AAAA-1749000081095.5027293.96华南广东佛山加盟AAAA-17516000078751.5050038.23华中江西南昌自营AAAA-17625000034068.0011887.77华中湖北武汉自营AAAA-17739000053487.0020005.77华中湖北宜昌自营AAAA-17815000049880.0017679.11华中湖北武汉自营AAAA-18316000042190.0015656.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-19534000072553.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-206200000103908.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西南重庆重庆自营AAAA-21514000015499.004637.82西南贵州贵阳加盟AAAA-21615000060446.0019841.12西南云南昆明加盟AAAA-217100000108658.0032389.82西南重庆重庆自营AAAA-21817000064530.0023309.43性性质数数据据加加盟盟自自营地地区区省省份份销售售额成成本本利利润销售售额华北北北京57255.619604.237651.41096077河北282721100958.25181762.75河南15040455806.3894597.62山东292384106193.52186190.48315259山西159630.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.15616121.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.0787179.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.79686840.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自自营数据性质地区门店数最低销售额最高销售额平均销售额销售总额自营东北1157062130192.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华东2813902.2101737560921570575.7华南84343110268275854606835.5华中274768120957.597863195725.5西北642953.581474.562474374845.5西南26044610865884552169104加盟 汇总6413902.2120957.5618433957961.3总计21813902.2406985.238645018846099.67数据地区销售总额份额东北10873195.77%华北2435820.112.92%华东10178745.3454.01%华南1262111.56.70%华中917350.74.87%西北12601226.69%西南1704631.039.05%总计18846099.67100.00%数据地区性质销售额成本利润 完成率 毛利率东北自营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.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%