You’re offline. This is a read only version of the page.
I want to track what days are higher in sales than others. Is there a way to run a report that shows the top five days in total sales? Or even if I can run a report where the total sales were over a given amount.
I tried detailed sales, "year-to-date", and then total sales over 5000 and it doesn't give me anything
thanks
*This post is locked for comments
I have the same question (0)
This query might do it:
select top 5 left(time,11),sum(total-salestax) from [transaction] group by left(time,11) order by sum(total-salestax) desc
Share
Report
All responses (
Answers (
