Sales by Current Month, Year, and Previous Year

I am looking to create a report that displays the current month sales for a particular salesman with grouping on their customers. The columns would then show SalesAmount, Profit, and Profit% for the current month, current year, and previous year. This would yield a total of 10 columns.
By using the report wizard I am able to produce the grouping by customer and all sales for that salesman. How can I then filter by current month? Current Year? Previous Year?

Any thoughts would be appreciated.


Please sign in to leave a comment.