Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel and Pivot Tables
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot tables | Excel Discussion (Misc queries) | |||
Excel 2003 Pivot tables | Excel Discussion (Misc queries) | |||
Excel 2002 Pivot Tables | Excel Discussion (Misc queries) | |||
Excel Pivot Tables | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |