| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Pivot Table Items That Have No Data
I have Excel 2007 pivot tables that refresh on data sets that sometimes have
no data for a particular item. I want to display all items, even zero or empty. Under Pivot Table Options there is a selection "Show items with no data on rows". It is not checked but it is also greyed out. Is there some other setting or condition that is keeping me from utilizing this option? Thanks in advance, J Austin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show only relevant no-data items in pivot table | Excel Discussion (Misc queries) | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Pivot table-show all grouped items | Excel Discussion (Misc queries) | |||
| Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Hybrid Mode
