Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table showing row field with no value
I have a pivot that has a list of people on the rows and hour for particular
categories across the top. I would like for it to list all the names of people regardless of if they have hours or not. Right now, the pivot will only show the people that have data in those particular categories. Can I get the pivot to show all the names? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table showing row field with no value
Right click the Names and select Field Settings - Check Show Items with No
Data -- HTH... Jim Thomlinson "Jaimed1010" wrote: I have a pivot that has a list of people on the rows and hour for particular categories across the top. I would like for it to list all the names of people regardless of if they have hours or not. Right now, the pivot will only show the people that have data in those particular categories. Can I get the pivot to show all the names? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
pivot table not showing field list | Excel Worksheet Functions | |||
Pivot table Data always showing up as "Count" | Excel Discussion (Misc queries) | |||
Pivot Table not showing subtotals | Excel Discussion (Misc queries) |