View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Monica Hall
 
Posts: n/a
Default PivotTable Group by Week and Month

I have created a Pivot Table the is groups my date by Days = 7. I then
wanted to add a Month grouping that would keep the days in the correct month
even if the week is split. I have done this in the past with no problem but
after upgrading to Office 2003 the pivot table is reverting the Day grouping
to 1. Any ideas how to correct this?