Re: Is there a way to build a sales report on a bu...

Bealzebubba · ‎07-13-2017

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 · ‎07-23-2017

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.

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