Right-click the Date field button
Choose Field Settings
Add a check mark to 'Show items with no data'
Click OK

GLS wrote:
I have a series of pivot tables set up as one report to show data activity
per month, however, some months there is no data and the month is excluded
from the table. This means the month are out of line on the different tables
from each other. How can I set it up so that when there is no data that
month it will show Zero or blank?

Many thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html