I have a pivot table containing dates, products and amount. I have right
clicked the date field to group the dates bi-weekly since the only dates in
the column are 1/15/2009,1/31/2009,2/15/2009,2/28/2009..etc YET i receive an
error that states "cannot group that selection".....i ensured it is in date
format...what else could cause this???