| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table
Two questions...
I have a delivery status column in a column field in the pivot table. It has 4 possible values. I want it to show all 4 even if the value for that category is 0. Currently the pivot table only displays those columns that have values which changes the size of the table. I want it to remain the same. When I double click on a total number it produces a new worksheet with that data. Is there a way to name the new worksheet with the title of that column? For example if the title is Late can I make the title of that tab Late? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
