Excel and Pivot Tables
Thank you for the response, however I am unsure where Blank is.
In the PivotTable Field window I only have visible options
SourceField Name Count field
Name
Summarize by - which Count is selected
Show data as: Normal
Base field - User Name
Where do I find the option for blank?
Thank you
"Peo Sjoblom" wrote:
From the dropdown in the count field deselect Blank
Now your grand total should be 3 (using your example)
--
Regards,
Peo Sjoblom
"Michelle" wrote in message
...
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,
|