Pivot Table Calculated Field

S

Steven

I have two fields in the Pivot Table Data. [CountOfFieldOne] is the count of
a field from the source data and [CountOfFieldTwo] is the count of another
field in the source data. Now I want to create another field in the PT that
is [CountOfFieldTwo]/[CountOfFieldOne]. Can this be done? I see where you
can do formulas but I dont see how you work the count of one field divided by
the count of another field.

Thank you for your help.

Steven
 
D

Debra Dalgleish

You can add two fields to the source data, where you calculate a count
for FieldOne and FieldTwo. For example, in the new fields, OneCount, use
the formula:
=COUNTA(G2)
where column G contains FieldOne.

Refresh the pivot table, and use the new fields in the calculated field.
I have two fields in the Pivot Table Data. [CountOfFieldOne] is the count of
a field from the source data and [CountOfFieldTwo] is the count of another
field in the source data. Now I want to create another field in the PT that
is [CountOfFieldTwo]/[CountOfFieldOne]. Can this be done? I see where you
can do formulas but I dont see how you work the count of one field divided by
the count of another field.

Thank you for your help.

Steven
Click to expand...
 
Top