I am trying to summarize my data in a Pivot Table. Here is an example of my
data.
There are 4 columns of data

Officer Name / Primary Num / Secondary Num / Car VIN

The Officer Name has one or more Primary Account Num.
The Primary Num is a 5 digit number.
The Primary Num has one ore more Secondary Num.
The Secondary Num is a 10 digit number & the first 5 digits are the Primary
Num.
The Secondary Num has only one VIN Num.

In a Pivot Table, I would like to summarize my data as follows:

Officer Num
Count of Primary Num by Officer Num
Count of Secondar Num by Primary Num

Is this possible?

Thanks,
Joe