Hi All,

Thanks for your responses. I've amended my query and now got it working fine 🙂

select
ar.Account_A__c as Account_ID,
a.SalesOrg__c as SalesOrg,
a.AccountNumber AS Account_Number,
MAX(CASE WHEN (ar.Relationship__c = 'RG') THEN...