I have several pivot tables linked to a single database with 12 fields
All database records are unique
One pivot table looks at just 2 fields from 12 as per the simplified example
below:
Field1 Field2
A abc
A abc
A def
B ghi
C hij

Would like the pivot table to count the unique occurences from Field2
against Field1

The result would be:
A 2
B 1
C 1

Any idea how this could be achieved within a pivot table?