Counting in Pivot table

T

Tony

The Group A of the 2 applicants have 3 applications each
i can only show how many applications in total - 6

How can i count how many applicants in Group A?

My Pivot table is Group, Applicant, Application

Then the table can show
Group A (2) Application (6)

Thanks a lot.

Tony
 
D

Debra Dalgleish

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

For example, to count unique applicants per group, where Group name is
in column C, and applicant name is in column D:
=IF(SUMPRODUCT(($C$2:$C2=C2)*($D$2:$D2=D2))>1,0,1)

Copy this formula down to all rows in the database.

In the pivot table, add Group name to the row area, and add this field
to the data area, and you'll get a count of unique applicants.
 
Top