<div>
To duplicate &quot;Count of FieldA&quot;, create a new column that just has a number 1 in it. Summing that column will give you the results you are looking for.
</div>


<div>
Hi Thomas,<br />
<br />
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? &nbsp;Thanks
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts, I am tring to create an Excel calculted pivot calculated field similar to this <br />
<br />
&quot;Count of field A&quot; &nbsp;divided by &nbsp;field B.<br />
<br />
the &quot;Count of field A&quot; or COUNT(field A) doesn't &nbsp;work in the Pivottable tools, Calculated Fields options.<br />
Any help would be appreciated.
</div>
</div>


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.

Excel Calculated field in Pivot

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.