I thought there was an easy way to group dates in a pivot table for example by year and then month and even weeks. In the attached, I do not see how this can be done. I thought I remembered seeing within the field list, for any date, it would furterh drill down to years, months, weeks even. I do not see this functionality in the attached.
How can I Group the attached pivot by year and then month? I would then want to be able to filter for anyone of those criteria.
thank you for the help. attached is in 2010.