I have a set of data in columns with an entry for a date in each row. I
would like to use a pivot table to calculate the totals in the rows by
month as oppose to by day. How do I roll up a dd/mm/yy format to
subtotal the months?

Regards

Filky


--
filky
------------------------------------------------------------------------
filky's Profile: http://www.excelforum.com/member.php...o&userid=11801
View this thread: http://www.excelforum.com/showthread...hreadid=492601