Pivot Table 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

Pivot Table Calculated Field
 

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.

Steven wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html