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
|