To get specific help, you'd need to provide some details about what
you're trying to do, and the layout of your pivot table.

A pivot table won't calculate a unique count. However, you could add a
column to the database, then add that field to the pivot table.

For example, if you want to count the customers in column A, use the
following formula in row 2:
=IF(COUNTIF(A$2:A2,A2)=1,1,0)

Copy this formula down to all rows in the database.

Add this field to the pivot table data area, as a Sum, and you'll get a
count of unique items, or a count of records. You could multiply this
field in your formula.


MCP wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html