Quote Originally Posted by DoriBeE
It won't let me group some of the dates though, keeps saying "cannot group that selection".
In general terms see: http://www.contextures.com/xlpivot07.html#Problems