select
COUNT_DISTINCT(Opportunity__r.Id) The_Count, 
  sum(Transaction_Allocation__c.Amount__c) amount, 
  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 ('012w0000000MQol','012w0000000hbgn')
 
AND Transaction_Allocation__c.GL_Code__c IN ('50020','50050','50060','50200') 
AND  Opportunity__r.Contact_Earliest_Record_Date__c> 2022-03-31)
 
 
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)