Hope someone can help - I am trying to create a pivot table of data which
covers 9 years and the first thing I want to do is sort the date into months
and quarters. When I take the date across to the table and try to group them
it is telling me I cannot group the selection and I notice the dates are
listed as
1/1/2000
1/1/2001
1/1/2002
1/1/2003
1/1/2004
1/1/2005
etc then the next day follows again sorted by each year. Any suggestions
would be welcome

Thanks