⑴ excel 数据透视表 中如何 插入公式
1、打开已经建好的数据透视表，选择一个单元格。
/iknow-pic.cdn.bcebos.com/9a504fc2d5628535f74581169fef76c6a7ef635b"target="_blank"title="点击查看大图"class="illustration_alink">/iknow-pic.cdn.bcebos.com/9a504fc2d5628535f74581169fef76c6a7ef635b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/9a504fc2d5628535f74581169fef76c6a7ef635b"/>
2、然后找到菜单栏的“分析”。
/iknow-pic.cdn.bcebos.com/b3119313b07eca8097a06ad09e2397dda1448364"target="_blank"title="点击查看大图"class="illustration_alink">/iknow-pic.cdn.bcebos.com/b3119313b07eca8097a06ad09e2397dda1448364?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/b3119313b07eca8097a06ad09e2397dda1448364"/>
3、在“分析”，菜单下找到字段，项目。
/iknow-pic.cdn.bcebos.com/cefc1e178a82b901c40990047c8da9773912ef65"target="_blank"title="点击查看大图"class="illustration_alink">/iknow-pic.cdn.bcebos.com/cefc1e178a82b901c40990047c8da9773912ef65?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/cefc1e178a82b901c40990047c8da9773912ef65"/>
4、在字段，项目下选择计算字段。
/iknow-pic.cdn.bcebos.com/cb8065380cd7912362e5c743a2345982b2b78084"target="_blank"title="点击查看大图"class="illustration_alink">/iknow-pic.cdn.bcebos.com/cb8065380cd7912362e5c743a2345982b2b78084?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/cb8065380cd7912362e5c743a2345982b2b78084"/>
5、接着在弹出的面板中，输入需要显示计算结果的列的菜单名称“综合”，公示=语文+数学，点击添加。
/iknow-pic.cdn.bcebos.com/29381f30e924b8990e9b2a0f61061d950a7bf666"target="_blank"title="点击查看大图"class="illustration_alink">/iknow-pic.cdn.bcebos.com/29381f30e924b8990e9b2a0f61061d950a7bf666?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/29381f30e924b8990e9b2a0f61061d950a7bf666"/>
6、这时候会发现在字段里多出来一个综合，点击确定。
/iknow-pic.cdn.bcebos.com/960a304e251f95ca9246c181c6177f3e67095251"target="_blank"title="点击查看大图"class="illustration_alink">/iknow-pic.cdn.bcebos.com/960a304e251f95ca9246c181c6177f3e67095251?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/960a304e251f95ca9246c181c6177f3e67095251"/>
7、最后回到数据透视表中来，就会发现计算公式以及计算结果已经存在与综合菜单下了。
/iknow-pic.cdn.bcebos.com/d1a20cf431adcbef880c2d31a3af2edda3cc9fc9"target="_blank"title="点击查看大图"class="illustration_alink">/iknow-pic.cdn.bcebos.com/d1a20cf431adcbef880c2d31a3af2edda3cc9fc9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/d1a20cf431adcbef880c2d31a3af2edda3cc9fc9"/>