Unique items in a Pivot table

[Shirish]

Let us say I have this data scenario

Customer Project Type
C1 P1 New
C2 P2 New
C2 P3 New
C3 P4 Existing

Using Pivot table, can I create a chart to show that I
have 2 New customers and 1 Existing customer

New - 2
Existing - 1

i want to create a chart of this table

 

[Debra Dalgleish]

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

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.