select
sum(Transaction_Allocation__c.Amount__c) amount, count(Transaction_Allocation__c.Amount__c) 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.CiWF_Payment_Method__c = 'Direct Debit'
     
AND
Transaction_Allocation__c.GL_Code__c IN ('50030', '50090'))
AND
((Opportunity__r.RecordTypeId ='012w00000006jGy'
AND
Opportunity__r.Recurring_Donation_Installment_Period__c != 'Monthly')
 
OR 
(Opportunity__r.RecordTypeId IN ('0122X000000ie1A')
AND
Opportunity__r.CiWF_Payment_Method__c != '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)