Pivot Table Row/Column
 

I'm trying to create a pivot table with a fixed number of rows and columns.
I want the same row and column headings to show up in the pivot table even if
some of the categories don't have any values associated with them at that
particular time.

How can I do this?

Thanks in advance for your help,

Jim

Right click on the pivot table field, choose Field Settings and check the
box for "Show items with no data".

Carlos

"jim314" wrote in message
...
I'm trying to create a pivot table with a fixed number of rows and
columns.
I want the same row and column headings to show up in the pivot table even
if
some of the categories don't have any values associated with them at that
particular time.

How can I do this?

Thanks in advance for your help,

Jim

Thanks! That helped tremendously. But I have another problem. There's a
value that's in my row heading that should not be there (and I've verified
that it shouldn't be there--it was and then I deleted it). How do I remove
that header value?

"CarlosAntenna" wrote:

Right click on the pivot table field, choose Field Settings and check the
box for "Show items with no data".

Carlos

"jim314" wrote in message
...
I'm trying to create a pivot table with a fixed number of rows and
columns.
I want the same row and column headings to show up in the pivot table even
if
some of the categories don't have any values associated with them at that
particular time.

How can I do this?

Thanks in advance for your help,

Jim

What version of excel are you using? I am using 2002. I don't remember how
it worked in previous versions, but I know pivot tables have changed
recently. If there is a down arrow next to your field name drop it down and
uncheck the column you don't want to see. At least that's how it works for
me. Hope this helps.

Carlos

"jim314" wrote in message
...
Thanks! That helped tremendously. But I have another problem. There's a
value that's in my row heading that should not be there (and I've verified
that it shouldn't be there--it was and then I deleted it). How do I
remove
that header value?

"CarlosAntenna" wrote:

Right click on the pivot table field, choose Field Settings and check
the
box for "Show items with no data".

Carlos

"jim314" wrote in message
...
I'm trying to create a pivot table with a fixed number of rows and
columns.
I want the same row and column headings to show up in the pivot table
even
if
some of the categories don't have any values associated with them at
that
particular time.

How can I do this?

Thanks in advance for your help,

Jim

I'm using 2003, but that was it! You have been so helpful.

Have a great new year!

"CarlosAntenna" wrote:

What version of excel are you using? I am using 2002. I don't remember how
it worked in previous versions, but I know pivot tables have changed
recently. If there is a down arrow next to your field name drop it down and
uncheck the column you don't want to see. At least that's how it works for
me. Hope this helps.

Carlos

"jim314" wrote in message
...
Thanks! That helped tremendously. But I have another problem. There's a
value that's in my row heading that should not be there (and I've verified
that it shouldn't be there--it was and then I deleted it). How do I
remove
that header value?

"CarlosAntenna" wrote:

Right click on the pivot table field, choose Field Settings and check
the
box for "Show items with no data".

Carlos

"jim314" wrote in message
...
I'm trying to create a pivot table with a fixed number of rows and
columns.
I want the same row and column headings to show up in the pivot table
even
if
some of the categories don't have any values associated with them at
that
particular time.

How can I do this?

Thanks in advance for your help,

Jim

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html


jim314 wrote:
Thanks! That helped tremendously. But I have another problem. There's a
value that's in my row heading that should not be there (and I've verified
that it shouldn't be there--it was and then I deleted it). How do I remove
that header value?

"CarlosAntenna" wrote:


Right click on the pivot table field, choose Field Settings and check the
box for "Show items with no data".

Carlos

"jim314" wrote in message
...

I'm trying to create a pivot table with a fixed number of rows and

columns.

I want the same row and column headings to show up in the pivot table even

if

some of the categories don't have any values associated with them at that
particular time.

How can I do this?

Thanks in advance for your help,

Jim





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