D
Debra Dalgleish
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:
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: