Is there a way to build a sales report on a bunch of, for example, Sunday?

[Bealzebubba]

 I'm looking for a way to build a report that shows a few weeks at a time. For example, the default reports will show me this Sunday v last Sunday or this Sunday v this Sunday last year but I can't, for example, stack all the Sundays on record. Am I just not understanding the report function or is this functionality not yet available?

Thanks for your time, 
Brad Knaub

[mtnwswbob]

One potential method:

Export the Sales Summary into excel (CSV) for the period you want to look at. (Last Month, Last Quarter, etc...)

• Transpose the rows and columns in the worksheet.
• Create a new column next to the date column (put it the first column 'A') for the days of the week.
• In Row 2 of your new column,  add in the function = text(B2, "dddd"), where B2 is the cell containing the first date in the Sales Summary column.
• Fill in the function to all of your 'day of the week' cells. 

Once you have that, you can filter by days of the week.