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?