I am having a problem, I am new to the Pivot Tables in Excel. Here is my same

username field Count field
user1 12
user2 2
user3
user4 4

I have been able to create a pivot table that will show me all the users,
there count field, and then a grand total of 18 for the count field. However
what I really need to do is count the number of users that have a value in
the count field.

Does anyone have any suggestions for me? When I go into the field settings
it is performing a count but a count on the value in the count field.

Thank you,