Pivot Table Calculated Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 Pivot table Calculated field misbehaving 1
Pivot Table Field based on two data area fields 3
Pivot Table - Calculated Field 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Problem if Source field name of pivot table changes 1
Pivot Table Calculate Field 1
Pivot Table Defaults 1
calculated fields in pivot tables 1

Back
Top