I would like my pivot table to display only the last 12 months of data. Is there a setting i could change somewhere to make it only give me the last 12 months? It is a lot of data points sum'd by month and year and is giving me all 12 of 2005 and then 6 of 2006. I would like the six of 2006 but only 7 and up of 2005.