Can I create PivotTable formula using count of field not sum?
Hi. When I insert a field into a PivotTable formula it uses only the sum of
that field. I need it to use the count of that field - but not the
worksheet-version of COUNT, but the PivotTable version. I wish to my formula
field to display the same result as if I had set the original field's
settings to "summarised by: count" in the 'Field settings' menu option. I can
do further calculations once I can do this. Cheers C
|