| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display No Data in Pivot
I am using Excell 2007, and I have create a pivot table, and I have a number
of reps that I want to display in my pivot and their sales amounts. In my data table, I have created "dummy" rows with the reps names, but sales $ are blank because they haven't sold anything. I want their name to show up in my pivot table as blanks. Right now only names with sales show up. I see under PivtoTable Options, under the Display tab ther is a box to click to "Show Itmes with no Data on Rows", but it is greyed out. Any idea how to un-grey out this option? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table doesn't display all data | Excel Discussion (Misc queries) | |||
| pivot table data display in cell | Excel Discussion (Misc queries) | |||
| Pivot Table: Display data | Setting up and Configuration of Excel | |||
| How to display repeating data in Pivot Tab | Excel Discussion (Misc queries) | |||
| Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
Threaded Mode
