Littlemalky
Board Regular
- Joined
- Jan 14, 2011
- Messages
- 223
Hi, I'm trying to build a query against a daily sales table that returns the sales for the last three days in each month for this year. I'm not sure how to create the function to limit just the last three days in each month. My purpose is to try to calculate the average daily sales in the last three days of the month to help us forecast where we will land.
Essentially, I want my results to show these columns: Date, Month, Sales.
example:
1/29/2016 | 1 | 50,000
1/30/2016 | 1 | 35,000
1/31/2016 | 1 | 42,000
2/27/2016 | 2 | 30,000
2/28/2016 | 2 | 15,000
2/29/2016 | 2 | 12,000
etc.
Essentially, I want my results to show these columns: Date, Month, Sales.
example:
1/29/2016 | 1 | 50,000
1/30/2016 | 1 | 35,000
1/31/2016 | 1 | 42,000
2/27/2016 | 2 | 30,000
2/28/2016 | 2 | 15,000
2/29/2016 | 2 | 12,000
etc.