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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Counting of Duplicated Names 4
how to count unique entries with multiple condition 6
SUM & OFFSET & PIVOT TABLE?? 0
Count Unique Values in a entire column, not just range 10
Pivot Table Calculated Field 0
Pivot Table Counting Text Data 0
Pivot Table Counting Text Issue 0
pivot table help 0

Top