select sum(Transaction_Allocation__c.Amount__c) amount, COUNT_DISTINCT(Opportunity__r.Id) The_Count, Opportunity__r.CiWF_Payment_Method__c, Opportunity__r.Country_of_Ownership__c, Opportunity__r.CurrencyIsoCode, CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c) Months, CALENDAR_YEAR(Transaction_Allocation__c.Close_Date__c) Years from Transaction_Allocation__c Where (Transaction_Allocation__c.Close_Date__c > 2022-03-31 AND Transaction_Allocation__c.Close_Date__c < NEXT_N_DAYS:1) AND (Transaction_Allocation__c.Stage__c IN ('Posted','Refunded','Failed','Refund','Reversal') AND ((Opportunity__r.RecordTypeId IN ('012w00000006jGy') And Opportunity__r.Date_Recurring_Donation_Established__c < 2022-04-01 AND Opportunity__r.Recurring_Donation_Installment_Period__c = 'Monthly') OR (Opportunity__r.RecordTypeId IN ('0122X000000ie1A') AND Opportunity__r.Direct_Regular_Donor_Start_of_FY__c = True)) AND Transaction_Allocation__c.GL_Code__c IN ('50030','50090')) AND Opportunity__r.CiWF_Payment_Method__c IN ('Credit/Debit Card','Direct Debit','Paypal') Group by Opportunity__r.CiWF_Payment_Method__c, Opportunity__r.Country_of_Ownership__c,Opportunity__r.CurrencyIsoCode, CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c),CALENDAR_YEAR(Transaction_Allocation__c.Close_Date__c)