Problem with Pivot Table and Dates

G

GarethG

When you drop the Date field into your pivot table, i.e. Months going
down the left hand side of the table, right click and select >Group &
Outline>Group

You can then choose from the list supplied in the dialog box that
appears to set the groupings my month year days etc.
 
Top