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
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
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
