You can group your data by weeks. Create your pivot table, stick the Date as a row or column field with your sales as the data field. When you're done, right-click on the date heading in the pivot table, select Group and Outline- Group click on Days and set the number of days to 7 with the spin button at the bottom.