Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) How to run a sales rep...

How to run a sales report for top five sales days

Like (0) Share

Report

Posted on 19 Jun 2011 16:29:33 by Goloknath

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

All responses (1)

Answers (0)

Suggested answer

Goloknath on 19 Jun 2011 at 23:14:54

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