View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJB AJB is offline
external usenet poster
 
Posts: 40
Default Pivot table filter - grouping

I often want to filter the "date" field in my pivot table to show sales in a
specific period e.g. last month only or the last three months. However, in
excel 2003 I am struggling to find how to do this other than having to select
every single relevant date from the drop down filter list, which can be time
consuming. (Previously I could do this in Excel 1997, by right clicking on
the field, and choosing "Group").
Does anyone know of a way I could do this in excel 2003?
Thanks.