View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MCVCOTE
 
Posts: n/a
Default Cannot group by date in a pivot table

The field itself is a date and each entry does have a date. I've grouped on
it before but can no longer do it. I've tried refreshing, updating the data,
and nothing seems to work. It brought in the data on a daily basis and I'm
trying to group it by month instead.

"MCVCOTE" wrote:

I get an message saying I cannot group on that selection.