View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mattgoof2005 mattgoof2005 is offline
external usenet poster
 
Posts: 28
Default Can't Group Dates in Pivot Table

I have a huge list(24808RX14C) forming a pivot table. For some reason, when
I right-click on the dates and go to grouping, it says "Cannot group this
selection." There is only 1 date in each month (cost collection day), but I
would like to group it by Year-Month. Any ideas on why this is happening?