多维透视图
该模板主要展示了交叉统计报表中中如何按照多行、多列进行统计。报表的列按照月进行统计，报表的行按照销售区域和省份进行统计。点击报表中【+】或【-】进行展开折叠。
葡萄城报表
1月2月3月4月5月6月7月8月9月10月11月12月总合计
区域省份
销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例销售额搭赠比例
广东省1,062,78915,3431.44%777,55961,5177.91%923,17224,9992.71%1,483,548101,2966.83%1,594,375184,09311.55%1,398,94881,2875.81%934,32137,9384.06%1,013,70865,0236.41%1,842,935213,45011.58%1,806,783233,98712.95%1,232,938131,08610.63%1,466,417115,9437.91%15,537,4941,265,9628.15%
广西壮族自治
20,0840.00%48,8873,9608.10%51,4847,44014.45%46,3880.00%24,9622,4369.76%48,4101,4883.07%47,5621,6803.53%20,7077443.59%39,3950.00%347,87917,7485.10%
区
海南省22,1980.00%11,8280.00%19,9722,24011.22%53,9982,2404.15%
福建省151,6270.00%190,84415,7948.28%219,1930.00%244,81624,85210.15%300,58615,1125.03%117,15211,92410.18%430,99818,5784.31%244,88910,4514.27%393,27688,58422.52%292,07824,2468.30%275,62911,8754.31%169,0607,7124.56%3,030,148229,1287.56%
华南
江西省20,8850.00%22,0200.00%23,0281,0084.38%48,7951,9263.95%27,5281,6926.15%17,4420.00%98,4120.00%13,0970.00%34,2971,8675.44%305,5036,4932.13%
湖南省82,46410,78013.07%116,1246,7205.79%194,25813,8707.14%145,51116,78311.53%70,5849,79213.87%138,3636,8964.98%172,64411,3526.58%223,50028,84212.90%127,7578,0646.31%77,2522,3843.09%82,0321,7882.18%1,430,490117,2718.20%
湖北省37,9505,86615.46%28,9121,6805.81%105,98610,75210.14%27,5003,36012.22%44,7201,4883.33%26,9022,2408.33%35,4482,6887.58%88,2653,9764.50%24,6402,2409.09%420,32234,2908.16%
小计1,255,38515,3431.22%1,050,86788,0918.38%1,367,34641,5453.04%2,003,018149,1387.45%2,169,486227,74810.50%1,682,770106,3636.32%1,622,15969,2624.27%1,534,08092,2466.01%2,524,429333,56413.21%2,460,856271,95311.05%1,639,597148,3299.05%1,815,841129,5507.13%21,125,8341,673,1327.92%
上海市19,27811,33458.79%42,04814,56834.65%8,5147,90292.81%24,6432,61110.60%59,77212,85221.50%87,6363,6364.15%241,89152,90321.87%
安徽省48,6284,4809.21%23,7921,1204.71%20,2900.00%12,8967926.14%52,2751,5112.89%17,3010.00%58,6531,2862.19%31,6910.00%11,2468647.68%276,77310,0533.63%
江苏省6,7060.00%28,8432,0947.26%15,5756163.96%108,0246,8996.39%143,1709,6676.75%219,73714,4236.56%139,95311,4458.18%171,88516,2509.45%178,08115,7738.86%148,2547,4385.02%1,160,23084,6057.29%
华东
浙江省50,2420.00%12,8520.00%28,6250.00%37,3720.00%57,7511,4782.56%41,7552,3785.70%14,9600.00%18,52110,87258.70%33,7273671.09%58,7682,9385.00%354,57318,0335.09%
山东省44,6922,0164.51%58,29819,29033.09%32,4107,77023.97%20,3620.00%26,7260.00%56,05810,43818.62%48,5285,65511.65%14,2611,74212.22%23,5053,12013.27%324,84050,03115.40%
小计50,2420.00%119,30417,83014.94%142,04235,95225.31%100,4029,5069.47%194,56214,8017.61%240,54311,9374.96%394,46831,3617.95%220,74217,1007.75%308,83141,26013.36%257,76117,8826.94%329,40917,9965.46%2,358,307215,6259.14%
天津市130,5387,4385.70%43,4963,6968.50%169,53029,69017.51%71,9407,0209.76%32,8861,5664.76%138,6206,7204.85%11,7600.00%142,9566,4964.54%109,6402,8002.55%151,1404,4802.96%132,8402,8002.11%223,60216,1227.21%1,358,94888,8286.54%
黑龙江省44,3527,39216.67%61,6000.00%35,7282,4646.90%93,99315,09116.06%54,6516,76612.38%83,72211,52613.77%4,6440.00%378,69043,23911.42%
北京市5,3360.00%7,3500.00%12,1971,1099.09%49,5421,0822.18%34,8185601.61%117,74015,54213.20%86,6144,5385.24%134,16710,3497.71%447,76433,1807.41%
辽宁省89,5127,9048.83%105,34314,40913.68%100,37313,11413.07%94,74715,79116.67%389,97551,21813.13%
河南省30,5981,4784.83%90,5157,2438.00%86,8583,5794.12%207,97112,3005.91%
华北
吉林省19,7120.00%27,1042,4649.09%28,2262,5669.09%75,0425,0306.70%
河北省
内蒙古自治区3,6960.00%3,6960.00%
小计130,5387,4385.70%48,8323,6967.57%176,88029,69016.79%71,9407,0209.76%89,43510,06711.26%200,2206,7203.36%101,4943,9423.88%309,11417,9465.81%238,45118,4517.74%547,61551,0069.31%490,40735,5577.25%457,16042,2629.24%2,862,087233,7958.17%
云南省16,8660.00%14,6070.00%20,4690.00%23,5170.00%21,1841,2706.00%50,9284,5628.96%9,7600.00%61,2393,4435.62%78,3974,8976.25%296,96714,1724.77%
新疆维吾尔自
30,0010.00%146,9120.00%23,2800.00%73,7380.00%185,6347,4264.00%76,6940.00%65,4200.00%244,1683600.15%845,8477,7860.92%
治区
陕西省104,6850.00%120,5185,9784.96%-2,9580.00%82,8430.00%25,9520.00%78,3450.00%89,7880.00%51,2760.00%112,1510.00%28,5320.00%90,5660.00%781,6975,9780.76%
重庆市148,5811,1200.75%99,23316,63716.77%125,56819,60815.62%211,89574,67535.24%78,0600.00%129,12013,65010.57%141,5310.00%84,3400.00%222,0881,7920.81%74,2780.00%189,1849,0804.80%167,2069,9005.92%1,671,083146,4628.76%
贵州省34,8380.00%33,4830.00%60,6030.00%4,1352,84768.86%39,5181,2323.12%41,4344,91211.86%24,1571,1134.61%238,16610,1044.24%
华西
四川省42,8882,0884.87%62,3282,2403.59%42,0720.00%101,3825,0404.97%27,7621,0443.76%43,0591,7924.16%48,5505601.15%117,7559,9018.41%68,1334,9187.22%192,50814,2937.42%82,2067,3008.88%264,64624,9439.43%1,093,28874,1196.78%
青海省9,2633,90742.18%7,7623704.77%2,7540.00%2,7540.00%22,5324,27718.98%
西藏自治区9,4860.00%13,7650.00%16,8860.00%40,1370.00%
山西省3,6000.00%2,8430.00%6,4430.00%
小计313,0203,2081.02%191,56218,8779.85%288,15825,5868.88%324,92679,71524.53%232,9901,0440.45%398,99515,4423.87%385,0884,4671.16%398,70014,3883.61%591,82418,6983.16%528,14715,5252.94%470,76924,7355.25%871,98241,2134.73%4,996,160262,8985.26%
总部166,54916,78810.08%646,18829,2744.53%204,75716,8008.20%214,1408,9104.16%260,28245,66217.54%148,9430.00%131,3534,1603.17%384,6888,9712.33%418,1065260.13%549,31112,4852.27%246,4050.00%718,16154,6117.60%4,088,880198,1874.85%
总部
小计166,54916,78810.08%646,18829,2744.53%204,75716,8008.20%214,1408,9104.16%260,28245,66217.54%148,9430.00%131,3534,1603.17%384,6888,9712.33%418,1065260.13%549,31112,4852.27%246,4050.00%718,16154,6117.60%4,088,880198,1874.85%
总合计1,865,49142,7772.29%1,987,691139,9387.04%2,156,446131,4516.10%2,756,066280,73510.19%2,852,595294,02710.31%2,625,489143,3265.46%2,480,63793,7683.78%3,021,051164,9125.46%3,993,552388,3399.72%4,394,760392,2298.92%3,104,937226,5037.29%4,192,553285,6326.81%35,431,2682,583,6377.29% |
|
