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?