If you want to do the aggregation by month in the pivot table you could
just use the 'group by' pivot table functionality, or add an extra
column to the data as =text(<date,"yyyy-mm") then use that field
directly in the pivot table.

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=519145