Pivot Table Calculation

[Tim Kuhn]

I currently have a Pivot Table that looks similar to the following:

User ID

John 12345
12346
12347

Jane 2345
2348

Greg 3499

What I am trying to do is add a calculated field that counts the # of ID's
per person, so I can track
- Number of users with 1 ID
- Number of users with 2 ID's
etc

Any help is appreciated

Regards
Tim

 

[Herbert Seidenberg]

In Layout: Drag ID out of ROW
DATA should say Count of ID