Excel数据透视表，非重复计数，你会么？
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">工作中，经常要用到数据透视表来数据统计与分析，<span style="color: black;">倘若</span>遇到非重复计数，你会用数据透视表来<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>的<span style="color: black;">营销</span>数据。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/f7c9d495dccb44308cb548bc5104e06d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955855&x-signature=1F8Ja5f4EyKT4fyDhO7UitiyBi8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此刻</span>，<span style="color: black;">咱们</span>需要统计，各个地区，<span style="color: black;">营销</span>了多少种商品，例如筛选衢州地区，它的种类是2种</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/8e36146f2e2e40478937faf42c785d91~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955855&x-signature=2UPEdakLgf16cwSMzAIjaZ6E0X0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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><span style="color: black;">插进</span>了一个数据透视表，<span style="color: black;">而后</span>将区域放在行标签，将商品放在值里面，它得到的结果，并非是<span style="color: black;">咱们</span>想要的，它<span style="color: black;">无</span>去除重复，</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">例如，衢州只是有3条信息，但<span style="color: black;">实质</span>上<span style="color: black;">营销</span>的品类<span style="color: black;">仅有</span>2种商品。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/78d1b75745584b569b90c9387c9c46cd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955855&x-signature=VplcNTFajsLSsI1BsD%2FC2zJAqi4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">正确<span style="color: black;">办法</span>：<span style="color: black;">运用</span>数据模型</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第1步，<span style="color: black;">咱们</span>需要<span style="color: black;">一样</span>的操作，<span style="color: black;">然则</span>重点是要勾选第5步，将此数据添加到数据模型中，如下所示</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ca4c25bf8c9a4fc298ae91421061c195~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955855&x-signature=PqMoREeePNifNUN43Tk6lTIsbfM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第2步，<span style="color: black;">咱们</span>将区域字段，放在行标签，将商品放入到值</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/64f8734340c947e7965f0b0c4d6bafad~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955855&x-signature=3n3MHKwKunfGZ%2BflWw0%2FraQMwnY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上看起来跟上面的操作是<span style="color: black;">同样</span>的，<span style="color: black;">实质</span>上当<span style="color: black;">咱们</span>添加到数据模型之后，<span style="color: black;">咱们</span><span style="color: black;">能够</span>在商品标签下，点击值字段设置</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/a41cd4c64bf443b1aae120e427bb49db~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955855&x-signature=lPrf2LenKduXUpnJ%2BsqoVnG3Vpo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span><span style="color: black;">咱们</span><span style="color: black;">能够</span><span style="color: black;">选取</span>非重复计数</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/bd0c54dc59504159a5b9476fac9b9c94~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955855&x-signature=SBst126WkSkukv7zNlXD2QgdF1g%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">就得到了正确的结果：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/6243a7ba9f5c4de08c8b3ff378c54ed4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955855&x-signature=zul108imvt4q%2BTke6PhXgIhn2lA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于这个技巧，你学会了么？动手试试吧！</p>
论坛的成果是显著的，但我们不能因为成绩而沾沾自喜。 顶楼主，说得太好了！ 你的努力一定会被看见，相信自己，加油。
页:
[1]