View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Convert date field to month in Pivot table

Put the date in a row field and then do the grouping.

Then drag that row field to the page field.



MESTRELLA29 wrote:

I have a Table wich has date fileds,
Date Order No. Qty Shipped
01-27-07
03-19-07
03-20-07

How do I go about to create a pivot table that groups this by month on the
Page Filed of the pivot table.


--

Dave Peterson