View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cbrah cbrah is offline
external usenet poster
 
Posts: 5
Default Group Pivot data by week

I am trying to automaticallly group a pivot table by week. When I go into
group... from the pivot table field, I get a dialog box that says I can not
group. I can manually select these dates and group them, but new dates are
added to my data source daily, and I would like this report to automatically
group them. What am I doing wrong?