pivot table

K

klp

I have a pivot table that pulls data from an Access database. The pivot table
has colums for each month. There is no data in the database for the months
2007-05 and 2007-06 but the columns still showed in excel in the pivot table.
(someone else created this and i have recently taken it over). Now i have
again, no data for 2007-07 but i can't get the empty column to show up in the
pivot table. Any ideas?

I added a blank record to the database, only filling in the date 2007-07 and
i was able to get it to show that way. But there is no blank record for
2007-05 and 2007-06. I would like to do this without adding the blank record,
for consistency.

Thanks in advance for any ideas.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table cell values 1
Pivot Table Counting Text Data 0
Formula to Look up values from a pivot table 1
Excel 2007 pivot table using analysis services cube as data source 0
How to Round a Date to a Month 2
Pivot table 0
My pivot table is not counting blank cells 0

Top