Pivot table filter required

Hi,

I am having problems populating a series of pivot reports and I want to know if I need to rearrange my data – and how.

What I need is a pivot report which has:

Filters: Division/SOS Managed/Business Unit and DATE. The date is the one I can not currently get. What I would like is a drop down box that would allow me to select an individual week, a number of weeks, a month etc.

The data it would then need to bring in is the range on the data sheet H3:CG12

Can anyone help?

I then need a separate table with the top 10 and bottom 10. Would this be two separated tables linked with a slicer?