chrislindsay
asked on
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.
"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.
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.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.