Pivot Table Grouping Dates by Month

[hkaplan2]

Hello all. In Excel 2010 I need to display dates in a pivot table column area, grouped by month. Some of the transactional source (sales) data does not exist in several months, so the pivot table only displays months with sales data (i.e. Jan Feb May July Oct, etc.).

Is there a way to force the pivot table to include all months (with or without data) across the page? I can add dummy records to accomplish this, but is there an Excel Pivot Table method?

Thanks.

 

[hkaplan2]

Never mind I found it in field settings.