Pivot table displaying last 12 months
 

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?


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

Pivot table displaying last 12 months
 

Right click the date header in the pivot table and select group. In the
dialog type a start and end date. The 'auto' check boxes will automatically
uncheck

When the resulting pivot table is build, remove the < and dates in the
filter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Acro" wrote in message
...

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?


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