Pivot table calculated Field from count of values

Question

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?

Possible duplicate of Add a calculated field in a Pivot table with a reference to a cell of the Pivot Table — Stoinov
– Stoinov, Commented Mar 2, 2018 at 17:44

pnuts · Accepted Answer · 2013-12-13 01:54:42Z

1

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.

answered Dec 13, 2013 at 1:54

pnuts

59.8k11 gold badges93 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ChrisHDog Over a year ago

I'm trying to do this in Excel 2016 and it looks like this is now under Analyze > Fields, Items, Sets > Calculated Field ... but I only have the baseline columns available and cannot put the count columns in the formula; is this something that has changed or is somewhere else?

Collectives™ on Stack Overflow

Pivot table calculated Field from count of values

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related