• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

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.
0
chrislindsay
Asked:
chrislindsay
  • 2
1 Solution
 
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
 
ThomasMcA2Commented:
Sorry for the confusion. Try this as a calculated field in the PT:

=Count(FieldA) / Sum(FieldB)

Open in new window

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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now