第8课：数据透视表布局解析-归类汇总！
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwS3ibqrkVCAl1uM0ek5AyiaD9bGt3cj6t4yx3UZaAzZSDmc9cVINHCqHlw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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;"><strong style="color: blue;"><span style="color: black;">“</span></strong><span style="color: black;"> Excel数据透视表，<span style="color: black;">按照</span><span style="color: black;">区别</span><span style="color: black;">归类</span>，<span style="color: black;">需求</span>进行汇总分析<strong style="color: blue;"><span style="color: black;">”</span></strong></span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">01</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></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></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/NldKzJicrVe7JGOurgr6mAQupBVlkp9uiaHG9DsSzcKoicrhlST5trqMMmTsvEtcND5fTUSo37qfEGicAmE758W7UQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSR5rzt0FvnSiaP8rw1fl8P4m3zvewT2qVvpiaWlIUkss7zc7HqpcIicHOw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSKiciascp5ngGX0R5gMtPPOmQhyhmFgDI7XzCc6lW1qSk3g0QwOoVCh5g/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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 style="color: black;">仅有</span>一个字段，如上面创建的所示，点或不点<span style="color: black;">归类</span>汇总的这三个选项，都是<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;">02</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">—</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">行标签中有2个字段</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSPPw18cBeUKMnLqfvvRA07CtuBYUWWrLlJaJR7tpOqL44R9pIibABCgA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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 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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSz2fubafvicIfljbI4fFJ4hYdFYnTvxmQIibgYW9UgYvian9CKTalohx8A/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSIib4Cwqg4tgb4icNqCove10NhhGpS1OJhG4hALibKFmhtIKGTbOFDzV8A/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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 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_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSedKnWPOTdUUg9YKAl3EmSiakshQpWBe2zXwb5WKMf5slLPPrOF3hZ3w/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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;">03</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">—</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">行标签有3个字段</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>是区域在最上方，商品在中间，月份在最下方放入</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>组的顶部<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_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSSWiagVXJzZEdsdaD4VV1vgoCOf601tr1Y09bSGKesfZSTgfdkjSk0Aw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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>点击的是不<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwS0xibfS2dNjcSfNel39SulZSN2kIPMJEteKWRhRcjIWyO1UyQYv3u5FA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSZntbXmLyQZd71zhxBQxm9qg8pNxuiauETryNGloLsQ7nc0PPtWGD11A/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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 style="color: black;">能够</span>总结，Excel会对最下面的字段不会汇总，会对每一个层级的字段都会进行汇总</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">03</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">—</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">列标签有2个字段，行标签1个字段</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>进行<span style="color: black;">归类</span>汇总，</span><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_png/NldKzJicrVe7hpSiaYL3nW9oQGgu2DjDwSwAhWlBUSMxgUAcaUYncFy4v7ibnZ6UoYyiawFX69FiaFNgaLhdgOoSkZA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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 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></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;">微X</span>公众号：Excel自学成才</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">ID:selftt</span></p>
谷歌外贸网站优化技术。 我赞同你的看法，你的智慧让人佩服，谢谢分享。
页:
[1]