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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156