Pivot Table Row/Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
I'm using 2003, but that was it! You have been so helpful.

Have a great new year!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Surpressing rows and columns with zero values in a pivot table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Typing Over Pivot Table Rows and Columns 1
Pivot Table - 3
Pivot tables - counting unique numbers 2
Pivot Table won't Get 'r done 1
conditional formula 1

Back
Top