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
|