View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
steven steven is offline
external usenet poster
 
Posts: 389
Default 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