I have a pivot table where I plot trends over time and want the months with no data to show in my pivot table. I have selected the "Show Items with no data" in the Field Settings and it shows the missing months. However, this has created a problem. I also only want to show certain years so I normally would filter by years (2010 and 2011 only, for example) but when I do this all the months for all the years (2009 thru 2011) under each year. For example:

2010 2011
Jan09, Feb09.......Nov11, Dec11, Jan 09, Feb09, ......Nov11, Dec11

I don't want any 2009 columns to show at all and I don't want the other year's months to show under the selected year, for example I don't want 2009 or 2010 months to show under 2011. (Note: It does not pull data, it shows as a "0" but it still has the column headings)



How do I get the Pivot table to show all the months, even if they don't have data for that month, but not do what I described above?

Thank you