counting records & pivot tables

T

Tim

I found this formula on this site:

=SUM(IF(FREQUENCY(MATCH(A1:A10,A1:A10,0),MATCH
(A1:A10,A1:A10,0))>0,1))

Can I incorporate it into a calculated field in a pivot
table? When I use it in the raw data, it does summarize
the uniqe records properly. Now I want that sum in my
pivot table. Having difficulty incorporating it.

Thanks,
 
Top