Thread: Adding blank future dates to a pivot table

Hi,

I am currently working on a spreadsheet that will show data from 2006-2008. I am working with data pulled from an excel query. Since the data only goes up to the present date I am unable to see future months that do not have data yet. Is there a way for me to display October-December 2008 in my pivot table? So far the only way I have come up with is to create a dummy record that shows no data for October-December. Is there a better way to do this?

Thanks for the response. I am looking to see the empty months on my pivot table with no data next to them. It's mainly for cosmetic reasons. Since it is only September right now my company has no sales data for October-December. I simply want those future months to appear in my pivot table even though they have no data. In fact, the months are not even in the data retrieve that the pivot table is being created from. The only solution I have come up with is to create a blank sales record for these future months. When I refresh the query in Excel the blank sales records are erased and I have to enter them again. I was just wondering if there is a quicker solution to this. Any help would be appreciated and I hope that I am not confusing anyone.