Excel Calculated field in Pivot

Hi Experts, I am tring to create an Excel calculted pivot calculated field similar to this

"Count of field A"  divided by  field B.

the "Count of field A" or COUNT(field A) doesn't  work in the Pivottable tools, Calculated Fields options.
Any help would be appreciated.
chrislindsayAsked:
Who is Participating?
 
ThomasMcA2Commented:
Sorry for the confusion. Try this as a calculated field in the PT:

=Count(FieldA) / Sum(FieldB)

Open in new window

0
 
ThomasMcA2Commented:
To duplicate "Count of FieldA", create a new column that just has a number 1 in it. Summing that column will give you the results you are looking for.
0
 
chrislindsayAuthor Commented:
Hi Thomas,

Do you mean create a new column in the raw dataset with a 1 in the column or to create a column in the Pivottable tools, Calculated Fields?  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.