Help Calculating Previous Fiscal Year Sales

Greetings All -    I need to calculate previous fiscal year to date sales data by sales category based on our our fiscal year. It starts September 1st, ends August 31st. I have my sales table relat...