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.Stage__c IN ('Posted','Refunded','Failed','Refund','Reversal')
 
AND
  
     (Transaction_Allocation__c.Close_Date__c  > 2022-03-31 AND                Transaction_Allocation__c.Close_Date__c  < NEXT_N_DAYS:1) 
 
  AND
   
 Opportunity__r.RecordTypeId IN ('012w00000006jGo')
 
      
AND
Is_this_First_Donation_from_Oppty__c = False
 
AND
Transaction_Allocation__c.GL_Code__c IN ('51060', '50130')
 
 )

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)