If big matrix report the "Categories" do not satisfy you (it show last 12 months) that possible to create some report but Custom Sql reports can't accept any parameters. You should be edit report every time when need some data to other period.
PS In new version of mmex Categories reports has subtotals. Do you need it?