I have a pivot table that outputs data for each month. In the layout I have the month and division in the page area. This are the only dropdowns I change to get data from a specific division for a specific month. The problem is when I select a future month where there is no data yet. The pivot table seems to concatenate two fields which expands the table. I would like for it to just put in zeros where there is no data yet. I hope that I explained that clearly...