Fixed Column Headings in a Pivot Table

[Fear Naught]

I need to show the value of Sales Opportunities in a pivot table with Months as column headings and the Sales Managers names as rows.

Where there is data in the underlying database (spreadsheet is linked to a SQL server database) then there is no problem. However if there is no data for a given month then of course by default the Pivot Table doesn't supply that month as a column.

Is there anyway to force a Pivot Table to show column headings in a non-dynamic form. So if there is no data for May the column is still there. This will make readability for my boss a lot easier.

On a similar subject is there also anyway I could fix the rows so that all Sales Managers show up even if there is no data.

I could do all this by using formulas (SUMIFS()) etc but would rather use a Pivot Table if possible.

Hope this is clear to all you Excel wizz kids!!

I am using Excel 2010 by the way.

Thanks,

 

[Fear Naught]

I have discovered how to show all the columns even when there is no data. It seems there is an option in "field settings".