View Single Post
  #1   Report Post  
Mary
 
Posts: n/a
Default Pivot table will not group a date field

I have a pivot table that I grouped the dates by month. I've been using it
for quite a while. I just refreshed it and the dates came ungrouped.And when
I select the date field and group, I get an error message saying "cannot
group that selection.