- Create a formula to determine which fiscal year the gift falls under:
if Month({Gf_Date}) >= 7 then Year({Gf_Date})+1 else Year({Gf_Date}) - Insert a Distinct Count summary on this formula
- Go to Report > Group Sort Expert
- Select the Distinct Count summary from the drop down
- Select Descending
- Click OK