select Opportunity__r.Country_of_Ownership__c,CALENDAR_MONTH(Opportunity__r.Ask_Date__c)themonth, CALENDAR_YEAR(Opportunity__r.Ask_Date__c)theyear, COUNT_DISTINCT(Opportunity__r.Id) The_CountThe_Count, sum(Opportunity__r.Ask_Amount__c) amount from Transaction_Allocation__c where Transaction_Allocation__c.Stage__c IN ('Ask Made','Pledged','Posted','Closed Lost') AND Opportunity__r.Ask_Date__c >2022-03-31 AND Opportunity__r.Ask_Date__c< NEXT_N_DAYS:1 AND Transaction_Allocation__c.GL_Code__c IN ('50141','50140','50180','50181','50270') Group by CALENDAR_MONTH(Opportunity__r.Ask_Date__c),Opportunity__r.Country_of_Ownership__c,CALENDAR_YEAR(Opportunity__r.Ask_Date__c)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter