Grouping by Dates

Hello,

We’re using Jet Reports Essential 2012. I need to create a report from a table using two fields “Departure Date” and “Amount” grouping all by Fiscal Year (starting from Apr 1st), Month, and Weeks.

I dropped two fields on a sheet that provide a nice detailed data with Amounts and all Dates. I also created added some calculated fields on a sheet for the Fiscal Year = YEAR(F8)+MONTH(F8>=3), Month=F8-DAY(F8)+1, Fiscal Year Start=IF(MONTH(F8)>=4,DATE(YEAR(F8),4,1),DATE(YEAR(F8)-1,4,1)) – to calculate a fiscal year week, and Fiscal Weeks=INT((DATE(YEAR(F8),MONTH(F8),DAY(F8))-I8)/7)+1.

So, it could take a minute to group it in SQL, SSRS, etc. by those calculated fields but I don’t know how to do it in Jet Reports.
I did go through all dates grouping topics in the Forum but still not clear how I could do it in my case so please don’t refer me there.

Please Help.