I have a db with a couple of tables.
Production
ID, Date, Bucket, Revenue
Production Calendar
ID, Start Date, End Date, Business Month, Calendar Year
Our monthly business does not go on calendar months. It ends on the next to last Friday of most months. I created the Production Calendar table to try and query the production table. I'm not having any luck.
Assume there are 10 unique Buckets. I would like to create a report that shows me the total of the 10 unique buckets individually by each month for a calendar year.
I have no problem doing this if i just enter a start date and an end date, it goes beyond my knowledge when i want to do this by month and bucket with multiple months on the report and that the month i need to use is not a regular calendar month.
Production
ID, Date, Bucket, Revenue
Production Calendar
ID, Start Date, End Date, Business Month, Calendar Year
Our monthly business does not go on calendar months. It ends on the next to last Friday of most months. I created the Production Calendar table to try and query the production table. I'm not having any luck.
Assume there are 10 unique Buckets. I would like to create a report that shows me the total of the 10 unique buckets individually by each month for a calendar year.
I have no problem doing this if i just enter a start date and an end date, it goes beyond my knowledge when i want to do this by month and bucket with multiple months on the report and that the month i need to use is not a regular calendar month.