Pivot table calculated Field from count of values

2019-07-15 02:41发布

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]

How can I do this?

1条回答
该账号已被封号
2楼-- · 2019-07-15 03:22

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.

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.

查看更多
登录 后发表回答