Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |