How to run a sales report for top five sales days

(0) Share

Report

Posted on by Community Member

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)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Re: How to run a sales report for top five sales days

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

Was this reply helpful? Yes No