I'm trying to structure a query that will let me get the sum and group by a time period.
Table has Account Number, Amount Purchased, Fiscal Year, Fiscal Period, Fiscal Week, and Date. It also has a few more fields, but these are the ones I'm concerned with.
SELECT DISTINCT...