Calculated Field. Dividing Count of Text by a Numeric Field

Calculated Field. Dividing Count of Text by a Numeric Field

The easiest way to create calculated fields using the total count of text, is to add a column to your source data, all with the number 1 in them.

Use this field in your pivot table to get the same results as your count fields.

The reason this works, is because Excel always uses the Sum of the Value Field and not the count when doing calculated fields. Annoying but true.

The above is an easy work around.

Calculated Field. Dividing Count of Text by a Numeric Field

Sum of Count Calculated Fields Excel

Sum of Count Calculated Fields Excel