Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 62
  • 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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