Yes, you should take Michael's suggestion and then use 4 calculated columns to parse out and then add up the date-range specific totals you're looking for.

Use an if statement that resolves to either the sale amount or 0, based on the transaction date's relation to the current date. When you summarize by customer and category, the subtotals in each column will be accurate for that cust/cat and date combination.