Excel Calculated field in Pivot

chrislindsay
chrislindsay used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Author

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
Sorry for the confusion. Try this as a calculated field in the PT:

=Count(FieldA) / Sum(FieldB)

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial