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.


--
Acro
------------------------------------------------------------------------
Acro's Profile: http://www.excelforum.com/member.php...o&userid=35456
View this thread: http://www.excelforum.com/showthread...hreadid=552411