I am very new to Pivot Tables. I was given responsibility to maintain a pivot
table on a excel 2000 sheet that shows weekly sales from an Acess
database.The problem is that the report dates that you can see are all
checked off. I was hoping to limit the report to the past 4 weeks only(Maybe
13)but I don't want to uncheck all the dates on the dropdown. I managed to
get into the Microsopft query and in the SQL view I found this query

SELECT WeeklySales.`Report Date`, WeeklySales.`SKU Description`,
WeeklySales.`POG Stores`, WeeklySales.`LW Total Units`, WeeklySales.`LW Total
$`, WeeklySales.`Status Code`
FROM WeeklySales WeeklySales
WHERE (WeeklySales.`Status Code`='Active') OR (WeeklySales.`Status
Code`='Inactive')

Is there a way I can manipulate this to get the data I need or is there
another way of doing this?

Than you

Diggsy