Thank you for your responses. I'm afraid I wasn't specific enough in my initial post. What I'm looking for is a way to automate the report so that it runs daily and always selects data from the current period, based on whichever period that day is in. I'd rather have the report know which period to pull data for than…

Yes, they represent fiscal months specifically in my case, not necessarily calendar months. There is some overlap since each segment of 7 days Sun-Sat is always within one fiscal period.