b1gc8v 发表于 2024-10-1 09:36:30

数据透视表进行数据统计，这几个技能你得会


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">透视表是统计神器，<span style="color: black;">那样</span>下面几个常用的统计数据的技巧你可能得会。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">按“年”进行统计</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">将上面的<span style="color: black;">营销</span>按年进行统计，效果图如下：</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/giavc6mpkmic0WkqnJm2Z8QhZfbukEAOqOQv7m6wxUjicmicdvd8JLatzubKWtyE8J9Ak3X281xsdjh43g3MAoVpJA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">详细</span>操作见下面的动态图：</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/giavc6mpkmic0WkqnJm2Z8QhZfbukEAOqOsqEddZzn5pMEGYPYuVodNbqhUg9nz9Iib4Vfic4yLYeLzUACUcuBgMlg/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">按“季度”进行统计<span style="color: black;">营销</span>区间为1000的<span style="color: black;">机构</span>代码为”2101“的商品的数量</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">将上面的<span style="color: black;">营销</span>按季度统计2101<span style="color: black;">机构</span>下<span style="color: black;">营销</span>区间为1000的间隔的商品数量。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/giavc6mpkmic0WkqnJm2Z8QhZfbukEAOqOr6Bgd4xCyEzUCCK4npkKRBNoE4g4zuicR2N4sHaJ94ibAN9ewn01L4OQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">详细</span>操作见下面的动态图：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/giavc6mpkmic0WkqnJm2Z8QhZfbukEAOqOkr7vSJhIyvbpLBKel9Ue9EicOfk8kN6kCwt4Bgo4IVl2t8Km219Rq4g/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">按年、月汇总<span style="color: black;">每一个</span>月的<span style="color: black;">营销</span>占全年的<span style="color: black;">营销</span>的占比</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">将上<span style="color: black;">‍</span></span></span><span style="color: black;"><span style="color: black;">面的<span style="color: black;">营销</span>按年份与月份统计计算每月的<span style="color: black;">营销</span>占全年<span style="color: black;">营销</span>的比重。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/giavc6mpkmic0WkqnJm2Z8QhZfbukEAOqONewW2fY87E2BiaxKrbCbrK00yyAKmJ5DLLurib2ZGDkgYeR6H63vJ8PQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">详细</span>操作见下面的动态图：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">按统计字段将透视表拆分至其他工作表中</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">将上面的<span style="color: black;">营销</span>按年份与月份统计后拆分至<span style="color: black;">每一个</span>工作表中。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/giavc6mpkmic0WkqnJm2Z8QhZfbukEAOqOINamZqzPibY4xCn0icGKpPeskazbUTje7okO2xP6aP9CC0WmkickoB0ng/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">详细</span>操作见下面的动态图：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">按“年、季度”进行统计</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">将上面的<span style="color: black;">营销</span>按年、季度进行统计。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/giavc6mpkmic0WkqnJm2Z8QhZfbukEAOqO72H4MSUrO4KbnBIicfnpdxIFgcVUvpzkfddnW18cM6CBhAOw4QMibJjA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">详细</span>操作图见下图：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>




qzmjef 发表于 3 天前

说得好啊！我在外链论坛打滚这么多年，所谓阅人无数，就算没有见过猪走路，也总明白猪肉是啥味道的。
页: [1]
查看完整版本: 数据透视表进行数据统计，这几个技能你得会