⑴ 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"/>