数据透视表计算字段从数值计数 [英] Pivot table calculated Field from count of values

问题描述

我有一个数据透视表，在值中我有一些字段数。

I have a pivot table, and in the values I have the count of some fields.

 Region |   Count of Actuals    |   Count of Budgets    |   Percentage of Actuals
 Asia   |   40                  |   80                  |   ???

我想将一个计算字段添加到数据透视表实际百分比公式应为[

I want to add a calculated field to the pivot table "Percentage of Actuals" The formula should be [Count of Actuals]/[Count of Budgets]

如何做到这一点？

推荐答案

地区已经被计算在内，所以没有必要在公式中加入Count of。我同意@Andre，这可能不是你想要的，但是对于你所要求的，只需添加一个计算字段的公式：实际/预算。

The Regions are already being counted so there is no need to include "Count of" in the formula. I agree with @Andre that this might not really be what you want, but for what you ask just add a calculated field with Formula: Actuals/Budgets.

选择您的PT，以便数据透视表工具出现在屏幕顶部，选项>工具 - 公式，计算字段...，添加一个明智的名称（也许<$在名称：框中，在公式：put = Actuals / Budgets ，确定。

Select your PT so that PivotTable Tools appears at the top of your screen, Options > Tools - Formulas, Calculated Field..., add a sensible name (perhaps %Act.) in the Name: box and in Formula: put =Actuals/Budgets, OK.

这篇关于数据透视表计算字段从数值计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！