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?

To display all the items, right-click on the Delivery Status field button
Choose Field Settings
Add a check mark to 'Show Items with No Data'
Click OK

There's nothing built in that will let you name the worksheet with the
name of the column.

xgirl wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks again, appreciate it.

"Debra Dalgleish" wrote:

To display all the items, right-click on the Delivery Status field button
Choose Field Settings
Add a check mark to 'Show Items with No Data'
Click OK

There's nothing built in that will let you name the worksheet with the
name of the column.

xgirl wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html