Pivot table calculated Field from count of values

excel pivot-table calculated-field
BoNDoK picture BoNDoK · Nov 11, 2013 · Viewed 10.4k times · Source

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?

Answer

pnuts picture pnuts · Dec 13, 2013

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.

Related questions

Excel: Pivot Table - Percentage of one value from another

My pivot table has 3 columns: Row label (expand/collapse items in each row) Count of Case Count of Assigned My DATA sheet has 2 sets of data: "Case" (line item for every bug, feature, etc.) "Assigned" (name of the person assigned …

Read More
How to create a calculated field that references a cell value in an excel pivot table

I have my data that looks like the following: Col1 | Value A | 1 B | 1 A | 3 C | 7 and a pivot table that sums up the values for col1. In addition I have an exchange rete in a another cell (in another worksheet) …

Read More
Simple Pivot Table to Count Unique Values

This seems like a simple Pivot Table to learn with. I would like to do a count of unique values for a particular value I'm grouping on. For instance, I have this: ABC 123 ABC 123 ABC 123 DEF 456 DEF 567 DEF 456 DEF 456 What …

Read More