Laureen:

Sales data is best pulled from Sales Anlaysis. There is only one transaction table.

As you summized you need a unique formula for each time frame.

The formula needs to look at the transaction date. If it's in the correct date range then output the appropriate amount else 0.

This detail report then needs to be summarized.