Drop Down Data Validation for Pivot Tables

[Sayth]

if I have a table which my pivot table is based off. (Just to clarify this spreadsheet is linked to an access database query). In my pivot table I want a report filter "Date" which I can select weeks(Monday to Sunday) and Months.

So that the user can select all weeks in Agust or just week 1 & 2 etc. I have asked around work and nobody has much of an idea the only suggestion has been to use data validation on the table so that the pivot gets this data. Is this a good option?

If it is any suggestions on a custom forumla to use for this data validation.

If its not a good option what should I do?

NB dates are in Australian format dd/mm/yyyy

 

[Sayth]

Nobody using grouping by months in drop down format in 2007?

 

[Robert Mika]

Maybe it woud be esier to add another column to indicate the week number and then to create PivotTable?

Could you show us your data?