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.