select Opportunity__r.Country_of_Ownership__c,CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c)themonth,
  CALENDAR_YEAR(Transaction_Allocation__c.Close_Date__c)theyear, sum(Transaction_Allocation__c.Amount__c) amount

from Transaction_Allocation__c
 
where 
 (Transaction_Allocation__c.GL_Code__c IN ('50140','50180','50181','50270','50260','50141')
AND

((Transaction_Allocation__c.Stage__c IN ('Ask Made', 'Identify','Research','Plan','Engage','Prepare Ask','Pledged')
AND
Opportunity__r.Pledge_Date__c > 2022-03-31)))

Group by  CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c),Opportunity__r.Country_of_Ownership__c,CALENDAR_YEAR(Transaction_Allocation__c.Close_Date__c)