@jokell You can group by a formula field, this is for July - June fiscal year

CASE WHEN TO_CHAR({trandate}, 'MM') >= 7 THEN TO_CHAR(ADD_MONTHS({trandate},12),'YYYY') ELSE TO_CHAR({trandate}, 'YYYY')  END