q = load "Opportunities_Sales_Ops";
q = group q by all;
q = foreach q generate sum('Total_MRR__c') as 'B';
p = foreach q generate 'B', 'B'*0  as 'zero';

q = load "ServiceOrders_JL";
q = group q by all;
q = foreach q generate sum('Total_MRR__c') as 'A';
q = foreach q generate 'A', 'A'*0  as 'zero';

z = cogroup p by 'zero', q by 'zero';
z = foreach z generate p.'B' as 'Gross Sales', q.'A' as 'Cancelled Sales', q.'B'-p.'A' as 'Net Sales';